What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

Question

Options

• AThe explain plan output is available graphically.
• BAn explain plan can be used to conduct performance analysis without executing a query.
• CAn explain plan will handle queries with temporary tables and the query profiler will not.
• DAn explain plan's output will display automatic data skew optimization information.

• A
  8% (3)
• B
  72% (28)
• C
  3% (1)
• D
  18% (7)

No community discussion yet for this question.