Untitled Page

Friday, December 21, 2012

SQL SERVER – Maximum Number of Index per Table


SQL SERVER – 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