You are a database developer. You plan to design a database solution by using SQL Server
2008. Users report poor performance of a long-running query in a database. You fail to
detect the cause of poor performance when you examine the estimated execution plan. On
viewing the actual execution plan, you discover that several tasks are CPU-intensive. You
need to ensure that you can view an estimated execution plan containing the most likely
actions. You want to achieve this goal by incurring minimum possible CPU overhead. What
should you do?
A.
Update statistics on the appropriate tables.
B.
Rebuild all indexes.
C.
Use the SET STATISTICS PROFILE ON statement.
D.
Use the SET STATISTICS XML ON statement.