Post reply

Why is there a limit in creating Non-Clustered index in a table?

  • May 26, 2010 at 4:17 am

    #221603

    We can create at the max. 249 non-clustered index in a table. Is there any specific reason for that count?

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • May 26, 2010 at 4:24 am

    #1172577

    SQL server 2008 can have up to 999 non clustered indexes, though the pracitcal limit is a lot smaller.

  • May 26, 2010 at 4:43 am

    #1172588

    Practically you should not have more than 5-10 nonclustered indexes per table. This would really degrade the performance if ur database is in OLTP environment. OLAP is fine having more indexes though.

  • May 26, 2010 at 6:55 am

    #1172667

    you can create 1000 index on single table.

    1- Clustered Index and

    999- non Clustered Index.

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

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