Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sriram Maximum No. of Indexes RE: Maximum No. of Indexes

  • March 20, 2009 at 2:14 am

    #963358

    Chirag (3/20/2009)

    In BOL under Creating Indexes (Database Engine) section its mentioned that there can be 249 non clustered indexes per table.

    But In BOL under Create table sections its mentiond 999 😉

    As others have already said, this is a documentation bug in BOL. The maximum number of nonclustered indexes was 249 on SQL Server 2005 and before, but the maximum has been increased to 999 for SQL Server 2008. Apparently, MS has overlooked one page when applying this modification to BOL.

    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/