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

microsoft-exams

One thought on “Which Transact-SQL command should you use?

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.