Getting details about operators in a graph

To view details for a single operator in a graph, double-click on its node.

To view details for multiple operators in a graph, select each one by clicking on it (the color changes); then select Node->Show details.

Alternatively, you can select each node and then select Show details from the pop-up menu.

You may only choose operators. If you choose any tables, indexes or table functions, the Show details action will be unavailable.

An Operator Details window opens for each of the selected objects, displaying information such as:

• The estimated cumulative cost (I/O, CPU instructions, and total cost) so far
• The cardinality (that is, the estimated number of rows searched) so far
• Tables that have been accessed and joined so far in the plan
• Columns of those tables that have been accessed so far
• Predicates that have been applied so far, including their estimated selectivity
• The input arguments for each operator.