Câu 16: 70-462: MCSA Administering Microsoft SQL Server 20122014 Databases
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 Tr…
Nội dung câu hỏi
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?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. ALTER INDEX IX_OrderDate ON CustomerOrder DISABLE
- B. ALTER INDEX IX_OrderDate ON CustomerOrder ENABLE — đáp án hiện tại
- C. ALTER INDEX IX_OrderDate ON CustomerOrder REORGANIZE
- D. ALTER INDEX IX_OrderDate ON CustomerOrder REBUILD
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.