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

Power BI Interview Questions and Answers

Power BI Interview Questions For Freshers The rising need for organizations to make decisions based on data has increased the demand for c...