What is the maximum number of indices per table in SQL SERVER?

Maximum number of indices per table in SQL SERVER

Basically we have two types of indexes.
1. Clustered Index.
2. Non- Clustered Index.

Up to SQL Server 2005 we can maintain 1  Clustered  index and 249 non clustered index. So total we can maintain 250 indices per table.

From SQL Server 2008 we can maintain 1 Clustered index and 999 non clustered index per table. So total we can maintain 1000 indices per table.

This is one of the good SQL Server Interview Question.

Share this post :

Post a Comment

Please give your valuable feedback on this post. You can submit any ASP.NET article here. We will post that article in this website by your name.

Support : Ranga Rajesh Kumar
Copyright © 2012. ASP.NET Examples - All Rights Reserved
Site Designed by Ranga Rajesh Kumar