Composite Non-Clustered Index?

• Mitchell Leitch

  SSC Rookie

  Points: 26

  More actions

  August 16, 2004 at 10:31 am

  #162436

  hi,

   

  Im trying to figure out what a Composite non-clustered index exactly is, i've read some articles on the website saying why i should use them but, i cant find a explanation on how to implement or even what they are.

   

  If anyone has an article or even an sql intro explanation on what they are and how to implement them that would be great

   

  Thanks,

  Mitch

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  August 16, 2004 at 12:14 pm

  #519203

  http://www.sql-server-performance.com/composite_indexes.asp

• Scott Coleman

  One Orange Chip

  Points: 27452

  More actions

  August 17, 2004 at 8:18 am

  #519346

  The link in the previous post is a very good discussion of composite indexes, to which I would add their discussion of clustered indexes.

  http://www.sql-server-performance.com/clustered_indexes.asp

  Just ignore the one paragraph that recommends a composite clustered index, believe the other paragraphs that say the opposite.