Index Sql Server 2008

Question

Hi friends What is the maximum number of index per table?

Jignesh Trivedi · Answer

hi please refer below link http://blog.sqlauthority.com/2009/06/29/sql-server-maximum-number-of-index-per-table/

Satyapriya Nayak · Answer

Hi Akshay For SQL Server 2005: 1 Clustered Index + 249 Nonclustered Index = 250 Index For SQL Server 2008: 1 Clustered Index + 999 Nonclustered Index = 1000 Index Please refer the below links http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx http://msdn.microsoft.com/en-us/library/ms143432.aspx Thanks