Maximum Number of Non-Clustered indexes per table?


In the earlier version of SQL Server maximum number of Non-clustered indexes per table was limited to only 249.

But, in later version of SQL Server 2005, maximum number of Non-Clustered indexes accepted in a table is: 999


This entry was posted in . Bookmark the permalink.

Leave a reply