Application Express User's Guide > Using SQL Commands > Using Explain Plan
You can view the explain plan the Oracle Optimizer uses to run your SQL command. You do not need to execute the command to view the explain plan.
Topics:
Viewing an Explain Plan
About Explain Plan Pane