Confused about Clustered indexes

• shahgols

  SSCrazy Eights

  Points: 9874

  More actions

  July 29, 2002 at 3:21 pm

  #63180

  Hello everyone,

  I have read up on clustered indexes, but I have the follwoing question. Do clustered indexes store the entire row of the table in the leaf pages or just the value of the column on which the clustered index is created on? Thanks in advance.

• dm

  Ten Centuries

  Points: 1135

  More actions

  July 29, 2002 at 7:03 pm

  #433606

  Clustered indexes store the entire row of the table in the leaf pages. You can only have one per table, so choose wisely.

  Diane