Pages

Men

rh

7/07/2012

What is the 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.

No comments :

Post a Comment