Difference between Cluster and Non-cluster index?
- 32 Answers
- 142686 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / palpantian
A clustered index is a special type of index that reorders
the way records in the table are physically stored.
Therefore table can have only one clustered index. The leaf
nodes of a clustered index contain the data pages.
A nonclustered index is a special type of index in which
the logical order of the index does not match the physical
stored order of the rows on disk. The leaf node of a
nonclustered index does not consist of the data pages.
Instead, the leaf nodes contain index rows.
| Is This Answer Correct ? | 339 Yes | 33 No |
Post New Answer View All Answers
Tell me can we use custom code in ssrs?
What will happen if a column containing char type data is changed to the nchar data type?
Which sql server table is used to hold the stored procedure scripts?
What is unpivot?
What is the function of sql server agent windows service?
What is code near application topology?
How to find Duplicate Records In table?
What is BLOCK statements in SQL?
What is sql profiler. What are the default templates with it? : sql server database administration
What is the difference between clustered index and primary key?
Which rendering formats are affected by the pagesize properties?
Tell me what is log shipping?
What is a group function explain with an example?
How to find the list of fixed hard drive and free space on server?
Where sql server user names and passwords are stored in sql server? : sql server database administration
