Difference between Clustered Index and Non clustered index

Forums SQLDifference between Clustered Index and Non clustered index
Staff asked 3 weeks ago

Answers (1)

Add Answer
monika gabani Marked As Accepted
Staff answered 3 weeks ago
CLUSTERED INDEX NON-CLUSTERED INDEX
Clustered index is faster. Non-clustered index is slower.
In clustered index, index is the main data. In Non-Clustered index, index is the copy of data.
A table can have only one clustered index. A table can have multiple non-clustered index.
Clustered index requires less memory for operations. Non-Clustered index requires more memory for operations.
Clustered index store pointers to block not data. Non-Clustered index store both value and a pointer to actual row that holds data.
In Clustered index, Clustered key defines order of data within table. In Non-Clustered index, index key defines order of data within index.
A Clustered index is a type of index in which table records are physically reordered to match the index. A Non-Clustered index is a special type of index in which logical order of index does not match physical stored order of the rows on disk.

Subscribe

Select Categories