Author Topic: Is there any difference between disabling CLUSTERED and NON-CLUSTERED Index?  (Read 169 times)

Offline Darren

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
Hi everyone, I'd like to ask you a big problem. Thank you How we do, is there any difference between disabling clustered and non-clustered index? It's urgent, please answer me quickly.
« Last Edit: October 30, 2017, 11:24:30 PM by Sofyene »



Offline Brandon

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
Re: Any difference between CLUSTERED and NON-CLUSTERED Index
« Reply #1 on: October 30, 2017, 11:25:27 PM »
An index is an on-disk structure associated with a table or view that speeds retrieval of rows from the table or view. An index contains keys built from one or more columns in the table or view. These keys are stored in a structure (B-tree) that enables SQL Server to find the row or rows associated with the key values quickly and efficiently.


 

Sitemap 1 2 3 4 5 6 7 8 9