Difference between Clustered Index and Non Clustered Index

By Santhosh N

This explains the difference between the Clustered Index and Non Clustered Index.

Clustered Index:
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.

Non-Clustered Index
A Non-Clustered 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 Non-Clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

Related FAQs

This explains different normalization forms in Database for designing the DB
Windows Server 2008 R2 is the part of windows family which has been released as part of six editions
Used to check if the column value is in numeric format
What is the real purpose of dual in oracle.
Device drivers designed for the 64-bit version of Windows don't work on computers running a 32-bit version of Windows
check the bit version of Windows you are running
Difference between Clustered Index and Non Clustered Index  (1942 Views)