Archives: 01/11/2011

EXPLAIN PLAN

Process Optimization Access Path Methods; Table Access (Full); Table Access (By ROWID); Index (Range Scan); Index (Unique Scan); Hash Scan; Cluster Scan; Dynamic Data Analysis; Join methods; Nested Loop Join; Merge Join Sort (only for equi-joins); Cluster Join; Hash Join; Optimization Strategies¬†(ALTER SESSION SET OPTIMIZER_MODE=option); Cost-Based approach (based to dynamic data analysis); Rule-Based approach (based…

Go Top