Description of the illustration sql_details_plan_graph.gif

The Plan subpage is shown.

The following label-value pairs are shown Data Source is Cursor Cache, Capture Time is Dec 30, 2012 3:56:03 PM, Parsing Schema HR, Optimizer Mode ALL_ROWS.

In the View section are the Graph and Table options. Graph is selected.

The Section Details section shows the following label-value pairs:

Operation is TABLE ACCESS BY INDEX ROWID, Object is EMPLOYEES (the value is a link), Object Type is TABLE, Order is 2, Rows is 3, Size (KB) is 0.059, Cost is 2, Time is 1, CPU Cost is 15893, I/O Cost is 2.

The graphic depicts a flow chart with EMP_NAME_IX leading to EMPLOYEES, leading to HASH JOIN. The JOBS object also leads to HASH JOIN. HASH JOIN then leads to HASH JOIN. DEPARTMENTS also leads to this HASH JOIN. HASH JOIN finally leads to SELECT STATEMENT.

End of description.