Execution Plans

GATHER_PLAN_STATISTICS hint doesn’t gather optimizer statistics as in those gather by dbms_stats.gather_table_stats. The GATHER_PLAN_STATISTICS hint captures execution statistics. For example, the number of rows actually returned by each operation in the execution plan. in order to gain the actual statistics from a query it is necessary to include the hint /*+ gather_plan_statistics */ which will […]