9/17/2018

SQL Server maximum number of indexes per table

In SQL server, maximum number of indexes are as:

In SQL server 2005 number of indexes per table as:

Clustered Index - 1

Non Clustered Index - 249

Total Indexes per table (Clustered + Non-Clustered) - 250

In SQL Server 2008 and 2012 number of indexes per table as:

Clustered Index - 1

Non Clustered Index - 999

Total Indexes per table (Clustered + Non-Clustered) - 1000

Note: You can put as many indexes per table but keep in mind, insert or update operation on that table will be slow due to many indexes.

To Learn more about SQL Server capacity, please go through Microsoft page:
https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-2017


No comments:

Post a Comment

Tableau interview questions and answers for experienced professionals

  Tableau Interview Questions and Answers for experienced professional 1. What is TABLEAU? Tableau  is the powerful and fastest visualizing ...