September 25, 2006 at 10:48 am
what is the difference between clustered and non clustered index
September 25, 2006 at 10:54 am
Hello Vamsi,
It would be better if you study the information provided in Books Online
Clustured indexes, architecture
nonclustered indexes, architecture
Thanks
Lucky
September 26, 2006 at 11:46 am
The clustered index defines the native physical order of the data on the disk. Consequently, there can be only one clustered index on each table. All other indexes on a table are non-clustered.
September 26, 2006 at 5:50 pm
Think of a phone book. The clustered index is the way the data is stored. There is no difference between the data and the clustered index, the index is the data. That's why there can be only one per table.
In the case of a phone book, it's on the last name of the person
The nonclustered index, is the additional index at the back of a phone book which lists things according to their types, like doctors numbers, emergency services that kind of thing. so there could be more than one of these and they are additional to the data.
you could have no index, in which case you'd have a 'heap' which would be like tossing all the phone numbers into a box on scraps of paper.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply