有些Features的使用是需要CBO的，有些Features的使用是自动Enable CBO的。记录一下。

The following features require use of the CBO:

  • Reverse key indexes
  • Function-based indexes
  • Star transformations and star joins
  • Query rewrite with materialized views
  • Hash joins
  • Bitmap indexes and bitmap join indexes
  • Index skip scans

The following features enable use of the CBO even Optimizer_mode is RULE:

  • Partitioned tables and indexes
  • Index-organized tables
  • SAMPLE clauses in a SELECT statement
  • Parallel query and parallel DML