Difference between Cluster and Non-cluster index?
- 32 Answers
- 140175 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 bit datatype? : Sql server database administration
Which is the main third-party tool used in sql server?
Why use “in” clause in sql server?
What is the default order of an order by clause?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is scalar user-defined function?
Explain primary key, foreign key and unique key?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What are security principals used in sql server 2005?
What is serializable?
What is history table in sql server?
What is SQL Azure?
What is dirty page?
How to call stored procedure using http soap?
Name few endpoints exposed by ssrs 2012?
