Search this blog

Wednesday, June 23, 2010

Maximum number of Index per table

For SQL Server 2005:
1 Clustered Index + 249 Nonclustered Index = 250 Index
http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx


For SQL Server 2008:
1 Clustered Index + 999 Nonclustered Index = 1000 Index
http://msdn.microsoft.com/en-us/library/ms143432.aspx


Reference: http://blog.sqlauthority.com/2009/06/29/sql-server-maximum-number-of-index-per-table/

No comments:

Post a Comment