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

Question

Yrae Franca de Pinho Gomes · Accepted Answer

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

Yrae Franca de Pinho Gomes · Answer

The explain plan output is available graphically.

Yrae Franca de Pinho Gomes · Answer

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

Yrae Franca de Pinho Gomes · Answer

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

List of questions