Friday, 25 May 2012

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


No comments:

Post a Comment