Câu 29: 70-464: Developing Microsoft SQL Server 2012/2014 Databases
You have database objects that were created by using the following script: The dbo. Customers table has 1 million rows. You discover that usp_GetCustomersByDate takes a long time to complete. The query plan used by the stored procedure is shown in the exhibit. (Click the Exhibit button.) You need to ensure that usp_Ge…
Nội dung câu hỏi
You have database objects that were created by using the following script: The dbo. Customers table has 1 million rows. You discover that usp_GetCustomersByDate takes a long time to complete. The query plan used by the stored procedure is shown in the exhibit. (Click the Exhibit button.) You need to ensure that usp_GetCustomersByDate completes as quickly as possible. What should you do?
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. Modify the stored procedure to include the OPTIMIZE FOR UNKNOWN query hint. — đáp án hiện tại
- B. Execute the sp_recompile 'dbo.GetCustomersByDate' statement.
- C. Execute the ALTER INDEXIX_Customers_CreationDate WITH REBUILD statement.
- D. Modify the stored procedure to include the OPTIMIZE FOR('1/1/2008') query hint.
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.