[Excluded indexes] Disabled index XML index Nonclustered index Index on a local temp table [Other restrictions] Multiple indexes cannot be specified within a single statement. [Online index operation] 
DROP INDEX