SQL Server: Maximum number of indexes per table
One of the favorite questions in a technical interviews seems to be: What is the maximum number of indexes for a table in the SQL Server database? Following is a breakdown of the maximum number of indexes by different versions of SQL Server. I am yet to come across a scenario when a table needed to have huge number of indexes like mentioned in the listing below.
Maximum Sizes | ||||
Object | SQL Server 7.0 | SQL Server 2000 | SQL Server 2005 | SQL Server 2008 |
Clustered Index | 1 | 1 | 1 | 1 |
Non-clustered Index | 249 | 249 | 249 | 999 |
References:
1. Maximum Capacity Specifications
2. Maximum Capacity Specifications for SQL Server 2005
3. Maximum Capacity Specifications for SQL Server
Leave a comment