Rule Based Optimizer

From Oracle FAQ
Jump to: navigation, search

The Rule Based Optimizer (RBO) is a SQL Query optimizer that uses heuristic rules to derive optimal query execution plans. RBO is enabled by setting OPTIMIZER_MODE=RULE in the server initialization parameter file, or by altering OPTIMIZER_GOAL for your session.

All applications should be converted to use the Cost Based Optimizer as the Rule Based Optimizer is not supported in Oracle 10g and above releases.

[edit] Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #