Features that Require the CBO
The following features require use of the CBO
Partitioned tables and indexes
n Index-organized tables
n Reverse key indexes
n Function-based indexes
n SAMPLE clauses in a SELECT statement
n Parallel query and parallel DML
n Star transformations and star joins
n Extensible optimizer
n Query rewrite with materialized views
n Enterprise Manager progress meter
n Hash joins
n Bitmap indexes and bitmap join indexes
n Index skip scans
Note: Using any of these features enables the CBO, even if the
parameter OPTIMIZER_MODE is set to RULE.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8102208/viewspace-614606/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
