Difference between Cluster and Non-cluster index?
- 32 Answers
- 141571 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 a non clustered primary key?
How to end a stored procedure properly in ms sql server?
What is after dml trigger?
Mention the differences between having and where clause.
What is page-level compression?
Why do we use trigger?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Explain how to send email from sql database?
Explain different backup plans?
How to link tables in sql server?
What the difference between UNION and UNIONALL?
Explain what is meant by replication of database?
What is a field name?
Why should one not prefix user stored procedures with ‘sp_’?
Difference between drill down and drill through report.
