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
Answer: B
Explanation:
Enable a disabled index by using the Transact-SQL ALTER INDEX REBUILD command.