Index Configurations of Table

Question

Hi Friends I want to know that How much a table can have different index configurations ?

Akkiraju Ivaturi · Answer

For Sql server 2005: 1 clustered index + 249 non clustered indexes = 250 index For Sql server 2008: 1 clustered index + 999 non clustered indexes = 1000 indexes There is a size limit on size of total indexes and it should exceed 900 byte limitation. If you have to include more than that size you have to consider included columns.