SQL SERVER Tips and Tricks
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
‹
›
Home
View web version
No comments:
Post a Comment