Reindexing a database

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715912

    Comments posted to this topic are about the item Reindexing a database

  • ako58

    Hall of Fame

    Points: 3235

    REBUILD [ WITH (<rebuild_index_option> [ ,... n]) ]

    Applies to: SQL Server (Starting with SQL Server 2012 (11.x)) and Azure SQL Database

    Specifies the index will be rebuilt using the same columns, index type, uniqueness attribute, and sort order. This clause is equivalent to DBCC DBREINDEX. REBUILD enables a disabled index. Rebuilding a clustered index does not rebuild associated nonclustered indexes unless the keyword ALL is specified. If index options are not specified, the existing index option values stored in sys.indexes are applied. For any index option whose value is not stored in sys.indexes, the default indicated in the argument definition of the option applies.

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71401

    Nice question, thanks Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply