Database Reference
In-Depth Information
Figure 11-3.
Steps carried out during the editing of a stored outline
Based on the example available in the
outline_editing.sql
script, I describe the whole process summarized by
Figure
11-3
. The purpose is to create and edit a stored outline to have a full table scan instead of an index scan for the
following query:
SQL> EXPLAIN PLAN FOR SELECT * FROM t WHERE n = 1970;
SQL> SELECT * FROM table(dbms_xplan.display(NULL,NULL,'basic'));
--------------------------------------------
| Id | Operation | Name |
--------------------------------------------
| 0 | SELECT STATEMENT | |
| 1 | TABLE ACCESS BY INDEX ROWID| T |
| 2 | INDEX RANGE SCAN | I |
--------------------------------------------