Pages

Wednesday 29 May 2013

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

So the correct answer is you can have upto 999 non clustered index per table from SQL Server 2008 onwards but in pervious versions this was limited to 249.

No comments:

Post a Comment