Understanding and Analyzing Oracle Execution Plans
Methods for Retrieving Execution Plans Database administrators and developers rely on several techniques to capture how the Cost-Based Optimizer (CBO) resolves SQL statements. Each method offers distinct advantages regarding runtime statistics, historical analysis, and overhead. 1. EXPLAIN PLAN FOR...