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.