NON-clustered indexes

• vssohal

  SSC-Addicted

  Points: 411

  More actions

  January 5, 2004 at 1:34 am

  #107566

  Why there are only 249 non-clustered indexes allowed ? why not more?

  
  Vss

• jordanac

  Hall of Fame

  Points: 3653

  More actions

  January 5, 2004 at 1:50 am

  #488633

  Hi,

  Maybe im still a little slow after my holiday at the coast! Why whould you need to have more than 249 non-clustered indexes on one table!

   

  

   

  
  Andy.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 5, 2004 at 1:55 am

  #488637

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=19701 might help you. And please post in the appropriate forum category.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]