Câu 1: 70-765: Provisioning SQL Databases
You administer a Windows 2008 server hosting an instance of Microsoft SQL Server 2012 Standard Edition. The server hosts a 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 heavily…
Nội dung câu hỏi
You administer a Windows 2008 server hosting an instance of Microsoft SQL Server 2012 Standard Edition. The server hosts a 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 heavily fragmenteD. You need to improve the performance of the IX_OrderDate index. The index should remain online during the operation. 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_OrderDateON CustomerOrder DISABLE
- B. ALTER INDEX IX_OrderDateON CustomerOrder ENABLE
- C. ALTER INDEX IX_OrderDateON CustomerOrder REORGANIZE — đáp án hiện tại
- D. ALTER INDEX IX OrderDateON 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.