Caveman's Blog

My commitment to learning.

SQL Server: Maximum number of indexes per table

leave a comment »


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

Written by coolgirlsblog

March 25, 2011 at 4:18 pm

Leave a comment