Author Topic: What is the difference between Cluster and Non-Cluster Index?  (Read 142 times)

Offline Marcel

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
What is the difference between Cluster and Non-Cluster Index?
« on: November 03, 2016, 04:38:02 AM »
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.



Offline Dominic

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
Re: The difference between Cluster
« Reply #1 on: October 30, 2017, 11:32:03 PM »
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


 

Sitemap 1 2 3 4 5 6 7 8 9