Difference between Clustered Index and Non clustered index – The Code Hubs

Difference between Clustered Index and Non clustered index

Raj dev Apr 23, 2022 0 17

Forums › SQL › Difference between Clustered Index and Non clustered index

0 Vote Up Vote Down

Raj dev

Staff asked 3 weeks ago

Answers (1)

Add Answer

1 Vote Up Vote Down

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.