Home Forums Article Discussions Article Discussions by Author Discuss content posted by Suresh Theyyath Indexes in SQL Server 2005 RE: Indexes in SQL Server 2005

  • January 19, 2010 at 7:57 am

    #1105433

    Tony Davis (1/19/2010)

    Apologies to all -- I've now made a correction to the answers so that it applies correctly to SQL Server 2005.

    Best,

    Tony.

    No, Tony. You haven't. 🙂

    SQL Server 2005 allows more than 250 indexes on a single table. Books Online says that you can have a maximum of 1 clustered, 249 nonclustered, and 249 XML indexes per table; I was not able to find the maximum number of full-text indexes per table. (I'm still hoping someone else finds this and posts a link).

    So the actual maximum is (499 + (maximum FT indexes per table)).

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/