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.

Also see[edit]

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 #