You are a database administrator for AIOTestKing.com. Users report that some reports are performing poorly. You ascertain that your tables have the appropriate indexes and that your queries should be performing optimally. You execute a SHOWPLAN statement on the poorly performing reports. You find that incorrect indexes are being used in some cases. You want the SQL Server 2005 query optimizer to automatically select the correct indexes. What should you do?
A.
Create a maintenance plan that includes an Update Statistics task.
B.
Create a maintenance plan that includes a Check Database Integrity task.
C.
Rewrite all poorly performing queries so that they use query hints.
D.
Rebuild the indexes and restart the server.
Explanation:
Statistics is used by the query optimizer to determine the optional query plan by estimating the cost of using an index to evaluate the query. The optional query plan may change over time and therefore you should update statistics on a regular interval to provide accurate information for the query optimizer.