Which Transact-SQL command should you use?

You administer a Microsoft Azure SQL Database database named Orders.

Users report that a query that filters on OrderDate is taking an exceptionally long time. You discover that an index named IX_OrderDate on the CustomerOrder table is disabled. You need to ensure that the query can use the IX_OrderDate index.

Which Transact-SQL command should you use?
A . ALTER INDEX IX_OrderDate ON CustomerOrder DISABLE
B . ALTER INDEX IX_OrderDate ON CustomerOrder ENABLE
C . ALTER INDEX IX_OrderDate ON CustomerOrder REORGANIZE
D . ALTER INDEX IX_OrderDate ON CustomerOrder REBUILD

View Answer

Answer: B

Explanation:

Enable a disabled index by using the Transact-SQL ALTER INDEX REBUILD command.