Post reply

NUMBER OF INDEX COUNT IN SQL SERVER 2005/2008

  • February 12, 2010 at 12:49 am

    #386303

    Dear All,

    Kindly provide the Index count information of both clustered,non-clustered index in sql server 2005/2008.

    Thanks,

    Anoop.S

  • February 12, 2010 at 1:54 am

    #1117912

    I'm sorry, I'm not sure what you're asking.

    Do you want to know the maximum number that you can have?

    Maximum number of columns?

    Something else?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 12, 2010 at 5:55 pm

    #1118378

    There are 1 and clustered index and 249 non-clustered index in 2005.

    1 clustered index and 999 non-clustered index in 2008

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply