Statistics & Cost Estimation

The optimizer uses statistics to choose the best query plan.

EXEC DBMS_STATS.GATHER_TABLE_STATS('HR', 'EMPLOYEES');

Cost estimation considers cardinality, selectivity, and access paths.