Question

Which of the following index operations require no additional disk space?

(a) ALTER INDEX

(b) DROP INDEX

(c) CREATE INDEX

(d) All of the mentioned

I had been asked this question by my college director while I was bunking the class.

I'd like to ask this question from Indexing Strategies in chapter Performance Tuning and Optimization of SQL Server

Answer 1

Right option is (d) All of the mentioned

The best I can explain: DROP INDEX does not require space when you are dropping a clustered index offline without specifying the MOVE TO clause and nonclustered indexes do not exist.