Difference between Cluster and Non-cluster index?
Answer Posted / seema
Clustered Index :-
1.There can be only one Clustered index for a table
2.usually made on the primary key
3.the logical order of the index matches the physical stored
order of the rows on disk
Non-Clustered Index
1.There can be only 249 Clustered index for a table
2.usually made on the any key
3.the logical order of the index does not match the physical
stored order of the rows on disk
| Is This Answer Correct ? | 86 Yes | 11 No |
Post New Answer View All Answers
what's new in sql server 2016?
When I delete any data from a table, does the sql server reduce the size of that table?
What is sql server profiler trace data file?
How to insert a new row into a table with "insert into" statements in ms sql server?
Can we return Data from 4(more than 1) tables in stored procedure?
What is the difference between value type and reference type?
What are the differences between local and global temporary tables?
Where do we use trace frag?
How to recreate an existing index in ms sql server?
What is filter index?
What do I need to start working with sql studio? : sql server management studio
How to use "begin ... End" statement structures in ms sql server?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is lock escalation? : sql server database administration
How many instances per computer are there in sql server 2000?