Thursday, December 15, 2011

Maximum number of Index per table

For SQL Server 2005:
1 Clustered Index + 249 Nonclustered Index = 250 Index


For SQL Server 2008:
1 Clustered Index + 999 Nonclustered Index = 1000 Index



For SQL Server "Denali":
1 Clustered Index + 999 Nonclustered Index = 1000 Index

No comments:

Post a Comment