Is there any difference between disabling CLUSTERED and NON-CLUSTERED Index?

Started by Camron, October 31, 2014, 01:17:32 PM

Previous topic - Next topic

Darren

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.

Brandon

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.