Difference between Cluster and Non-cluster index?
- 32 Answers
- 138320 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
What is openrowset sql server?
What are the types of containers in ssis?
What are different types of constraints?
How to verify the port number of the sql server?
What is the difference between primary key and unique constraints?
how you can deploy an ssrs report?
What is the difference between the 2 operating modes of database mirroring?
What are constraints?
how to define testing of network layers? : Sql server database administration
SQL Server Architecture ?
How to resolve the orphan use problem? : sql server security
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What is 3nf normalization form?
Can a unique index be created on a column, which contains null?
How to create a user to access a database in ms sql server using "create user" statements?
