This figure is a section of a screen of the Oracle Enterprise Manager Scratchpad utility. It contains a tree depicting the execution plan steps for the SQL statement discussed in the text.

• Step 1 is a full table access on the employees table
• Step 2 is an unique index scan on the jobs table
• Step 3 is a table access on the jobs table by the rowid determined in Step 2
• Step 4 is a nested loop operation on Steps 1 and 3
• Step 5 is an unique index scan on the departments table
• Step 6 is a table access on the departments table by the rowid determined in Step 5
• Step 7 is a nested loop operation on Steps 4 and 6
• Step 8 is the SELECT statement that returns rows to the user