Oracle Query Window includes a Explain Plan toolbar button that allows you to examine the execution plan that the database follows to execute a specified SQL statement. An execution plan is the sequence of operations Oracle performs to run the statement.

This assists advanced users in manually tuning their SQL statements.

You can find the documentation for Explain Plan in the following Query Window section: Examining the Execution Plan of a SQL Statement.