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