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

Question

Mounir Mrabet · Accepted Answer

An explain plan can be used to conduct performance analysis without executing a query.

Mounir Mrabet · Answer

The explain plan output is available graphically.

Mounir Mrabet · Answer

An explain plan will handle queries with temporary tables and the query profiler will not.

Mounir Mrabet · Answer

An explain plan's output will display automatic data skew optimization information.

List of questions