December 2002
Intermediate to advanced
928 pages
85h 29m
English
The Oracle optimizer should select the best execution plan for SQL statements. If there is a problem with the performance of a SQL statement, you may want to see the execution path choices the optimizer made for the statement. The EXPLAIN PLAN statement can produce this information.
The execution plan produced by the EXPLAIN PLAN statement may not exactly match the execution plan used at runtime, because of differences in the two environments. The SQL_PLAN data dictionary views, new in Oracle9i, contain information about the actual execution plan used at runtime. See Chapter 6 for more information about these views.