General information
Forum:
Microsoft SQL Server
Thank you Michael for taking the trouble to explain.
Appreciate it, thanks.
>>Michael, would you care to explain to me what is and the diff.
>>between NC(non-cluster) indexes and cluster indexes. Thanks.
>
>First, understand that a SQL Server index is structured like a tree. A clustered index has two very important properties. First, the leaf level of the index is actually the data. The index sits on top of the table. This causes the second important property - the table is physically sorted based on the clustered index key. And this sorting is maintained by the server. Because of this, you can only have one clustered index.
>
> Root - Internal Nodes - Leaf (table data pages)
>
>
>Non-clutered indexes have a leaf level that is seperate from the table. At the leaf level, all keys contain a ptr to the the row within the table.
>
> Root - Internal Nodes - Leaf - Table data pages
>
>
>-Mike
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only