early birds of 11gR2 CBO
有个，提到了一些oracle11gR2中CBO增强的地方。看了一下，可能以下几个功能会用到。其它的马马虎虎。
- OPTIMIZER_USE_INVISIBLE_INDEXES
- OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES & OPTIMIZER_USE_SQL_PLAN_BASELINES
- Extended statistics for multiple columns real-world relationships.
- Copying table statistics
Very often with partitioned tables, when add a new empty partition .
BEGIN
DBMS_STATS.COPY_TABLE_STATS (‘SH’,’SALES’,’SALES_Q3_2000′, ‘SALES_Q4_2000′, FORCE=>TRUE);
END;