-----------------------------
| 0 | select STATEMENT | | 1 | 3 | 3 (0) | 00:00:01 |
|* 1 | INDEX RANGE SCAN| I_TEST | 1 | 3 | 3 (0) | 00:00:01 |
---------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - access("COL1"='00')
Outline维护
停止db使用outline功能：
alter system set use_stored_outlines=false;
disable/enable具体outline：
alter outline ol_name disable;
alter outline ol_name enable;
删除outline category：
9i, 10g: exec dbms_outln.drop_by_cat(‘category_name’);
8i: exec outln_pkg.drop_by_cat(‘category_name’);
outline相关视图
dba_outlines
检查outline是否存在
select
name, category, owner from dba_outlines;
dba_outline_hints
该视图列出outline的hints内容
|