Which of the following adds MOVE TO clause ?
A. DROP INDEX
B. ALTER INDEX
C. UPDATE INDEX
D. CREATE INDEX
Answer:A
Which of the following adds MOVE TO clause ?
A. DROP INDEX B. ALTER INDEX C. UPDATE INDEX D. CREATE INDEX
Explanation:DROP INDEX statement enables moving data from a clustered index to another filegroup or partition scheme.