What is the Maximum Number of Index per Table?

 Posted by Kundan64 on 1/24/2013 | Category: Sql Server Interview questions | Views: 2405 | Points: 40
Answer:

In SQL Server 2005:
1 Clustered Index and 249 Nonclustered Index, Total 250 Index per table.

For SQL Server 2008:
1 Clustered Index and 999 Nonclustered Index, Total 1000 Index per table.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response