You need to identify the information that will be useful for the optimizer. What should you do?
Check Point Certification
Palo Alto Networks Certification
You use Microsoft SQL Server Profile to evaluate a query named Query1. The Profiler report indicates the
At each level of the query plan, a low total number of rows are processed.
The query uses many operations. This results in a high overall cost for the query.
You need to identify the information that will be useful for the optimizer.
What should you do?
A. Start a SQL Server Profiler trace for the event class Auto Stats in the Performance event category.
B. Create one Extended Events session with the sqlserver.missing_column_statistics event added.
C. Start a SQL Server Profiler trace for the event class Soft Warnings in the Errors and Warnings event
D. Create one Extended Events session with the sqlserver.missing_join_predicate event added.