Sanjay Agrawal

• May 30th, 2006

 

Cluster index just changes the whole physical structure of the Table
the data of table is stored in the data pages they are 8 kb pages.

Cluster index stores the data ordering wise Ascendingly.
suppose u have inserted the data started on A,B, and D and now if any person will enter the data started from C then the entries for D data would be changed to next locations

It would changes the whole structure of the tabel

listen here cluster index can be created only on one fields

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

Cluster index stores the data ordering wise Ascendingly.
suppose u have inserted the data started on A,B, and D and now if any person will enter the data started from C then the entries for D data would be changed to next locations

It would changes the whole structure of the tabel