SQL> delete from plan_table;

3 rows deleted.

SQL>
SQL> explain plan for select /*+full(a)*/ * from T_PEEKING a where b = :V;

Explained.

SQL>
SQL> select lpad(' ', 2*(level-1))||operation||' '||options||' '||
2 object_name||' '||decode(id, 0, 'Cost='||position) "Query
3 Plan_Table"
4 from plan_table
5 start with id = 0
6 connect by prior id = parent_id
7 ;

Query
Plan_Table
--------------------------------------------------------------------------------
SELECT STATEMENT Cost=75
TABLE ACCESS FULL T_PEEKING

SQL>

Related posts:

1. Oracle9i优化器介绍（上）
2. Oracle9i优化器介绍（下）
3. AutoTrace
4. 用SQL处理多行汇聚问题
5. drop table遭遇ORA-604 / ORA-1422