Difference between Cluster and Non-cluster index?
- 32 Answers
- 138375 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
What is the difference between Normalization and De-normalization?
What is BCP? When does it used in sql server 2012?
What is dknf in normalization form?
What does it mean to normalize data?
Is ssrs support other database except ms sql server?
What are the ways available in sql server to execute sql statements?
What are triggers? How do you invoke a trigger on demand?
How to generate create function script on an existing function?
what stored procedure can you use to display the current processes? : Sql server administration
Does partitioning improve performance sql server?
What is the impact on other user sessions when creating indexes?
What is msdb database? : SQL Server Architecture
What the different types of Replication and why are they used?
What is the difference between executequery () and executeupdate ()?
How do indexes help, types?
