Post reply

Reindexing a database

  • September 17, 2019 at 12:00 am

    #3674516

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

  • September 17, 2019 at 4:17 am

    #3680546

    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.

  • September 17, 2019 at 5:50 am

    #3680559

    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 2 (of 2 total)

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