Home Forums SQL Server 2008 SQL Server 2008 Administration Create index with DROP_Existing RE: Create index with DROP_Existing

  • August 20, 2012 at 6:09 am

    #1527543

    Grant Fritchey (8/17/2012)

    Drop does exactly what it says. It's going to drop the existing index and then rebuild it. No, it won't leave the existing index available while it does the rebuild... unless you're also doing ONLINE operations with the index. Then the other index will stay in place while the create operation occurs. This will take extra tempdb space, so be ready for that.

    Can u rebuild index online? I thought index rebuild must be offline, index reorg is done online. Please advise.

    Thanks,

    SueTons

    Regards,
    SQLisAwe5oMe.