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.
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