Webastor - Programming Tips and Tricks

Programming language => Sql => Topic started by: Darren on October 31, 2014, 01:17:32 PM

Title: Is there any difference between disabling CLUSTERED and NON-CLUSTERED Index?
Post by: Darren on October 31, 2014, 01:17:32 PM
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.
Title: Re: Any difference between CLUSTERED and NON-CLUSTERED Index
Post by: Brandon 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.