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.
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.