Thursday, March 22, 2012

Cluster index and non Cluster index

where use Cluster index and non Cluster index
what different between Cluster index and non Cluster index
It very huge topic and has been discussed many times on this forum. I
suggest you get a book "Inside SQL Server 2000" written by Kalen Delaney
and read about the subject
The difference is that leaf level of CI contains actual data as for
CI -leaf level contans pointers to the actual data.
"harshad" <harshad7_jp@.hotmail.com> wrote in message
news:56BF2206-FACD-4220-A388-0F2D53568D7A@.microsoft.com...
> where use Cluster index and non Cluster index what different between
> Cluster index and non Cluster index
>

No comments:

Post a Comment