Tag Archives: sql server 999 non clustered index

How many Non Clustered Index can be created on a single table?

During my on of the training session, I used a term that we can multiple NON clustered Indexes, instantly one of the participants  was very specific about number and said, we can have upto 249 non clustered index in a table. I instantly said, Your information in not upto date, and you need a course [...]