Interpreting Oracle Execution plan-to be continued

Cost (%CPU): The optimizer estimates the costs of completing the current operation (including the cost of sub-operations), which is the sum of the IO cost and CPU cost.
The IO cost is the most basic price.
For CPU costs, by default, the optimizer calculates the CPU cost, and the CPU cost is converted from a specific conversion formula to the IO cost, depending on the system configuration.


Time/e-time: The optimizer estimates the time it takes to complete the operation, which is the cumulative time of its child operations, and if the output is collected at the actual time in the plan, it will be displayed as e-time to the actual time difference;

Interpreting Oracle Execution plan-to be continued