How many NON-CLUSTERED indexes are allowed in a single table by SQL Server.

By Santhosh N

This explains about the creation of NON-CLUSTERED indexes and maximum allowed.

As we all know there are two types of indexes that can be created in Database namely CLUSTERED and NON-CLUSTERED.


SQL Server allows maximum up to 249 NON-CLUSTERED indexes that can be created in single table.

This has been increased to 999 in SQL Server 2008 R2 version for both 32-bit and 64-bit server.

Related FAQs

This explains how (in which order) the SQL Server stores the records in the table.
This explains how to set DEADLOCK_PRIORITY in SQL Server and its benefits in doing so.
This explains how to use TEMP tables in the SELECT query for better query performance.
This explains the advanced query tuning concepts of the SQL Server in terms of using joins
This explains the QUERY_GOVERNOR_COST_LIMIT option for controlling long running queries in the SQL Server.
This explains where to have a loop if at all required to have one to get the desired result from the database.
How many NON-CLUSTERED indexes are allowed in a single table by SQL Server.  (6276 Views)