Difference between Cluster and Non-cluster index?
- 32 Answers
- 142106 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / kshirsagar sambhaji
The difference is that, Clustered index is unique for any
given table and we can have only one clustered index on a
table. The leaf level of a clustered index is the actual
data and the data is resorted in case of clustered index.
Whereas in case of non-clustered index the leaf level is
actually a pointer to the data in rows so we can have as
many non-clustered indexes as we can on the db.
| Is This Answer Correct ? | 48 Yes | 19 No |
Post New Answer View All Answers
How would you choose between a clustered and a non-clustered index?
What is dknf in normalization form?
How do I start sql server?
Can we write ddl in trigger?
what is memory-optimized nonclustered indexes
How do I debug a stored procedure in sql server?
Where is my database stored on the hard disk in ms sql server?
how you can get the list of largest tables in a database? : Sql server administration
Do you know how to implement service broker?
How to change the system date and time from SQL Plus Terminal ?
What is table valued function and scalar valued functions?
What extended events?
How to store and query spatial data?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
Issues related in upgrading SQL Server 2000 to 2005 / 2008
