Hi Friends
I want to know that How much a table can have different index configurations ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Akkiraju IvaturiPosted Aug 22, 2012, 9:49 AM
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.