What is the difference between Cluster and Non-Cluster Index?

Started by Devin, November 03, 2016, 04:38:02 AM

Previous topic - Next topic

Marcel

Hi everyone, I have a big question about a particular case, I'd like to know what is the difference between cluster and non-cluster index? Please give me an answer please as soon as possible.

Dominic

A clustered index actually describes the order in which records are physically stored on the disk, hence the reason you can only have one. A Non-Clustered Index defines a logical order that does not match the physical order on disk