Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rule based Optimiser in 10g

KersMar 31 2004 — edited Mar 31 2004
Can anyone tell me if there is still a rule based optimiser in 10g, i have heard that it has been removed? Is this correct?

Comments

211182
Here's what's in the Database Performance Tuning Guide 10g Release 1:

Rule-based Optimization (RBO) Obsolescence

RBO as a functionality is no longer supported. RBO still exists in Oracle 10g Release 1, but is an unsupported feature. No code changes have been made to RBO and no bug fixes are provided. Oracle supports only the query optimizer, and all applications running on Oracle Database 10g Release 1 (10.1) should use that optimizer. Please review the following Oracle Metalink desupport notice (189702.1) for RBO:

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_
database_id=NOT&p_id=189702.1


You can also access desupport notice 189702.1 and related notices by searching for "desupport of RBO" at:

http://metalink.oracle.com


Notice 189702.1 provides details about the desupport of RBO and the migration of applications based on RBO to query optimization.

Some consequences of the desupport of RBO are:

CHOOSE and RULE are no longer supported as OPTIMIZER_MODE initialization parameter values and a warning is displayed in the alert log if the value is set to RULE or CHOOSE. The functionalities of those parameter values still exist but will be removed in a future release. See "OPTIMIZER_MODE Initialization Parameter" for information optimizer mode parameters.
ALL_ROWS is the default value for the OPTIMIZER_MODE initialization parameter.
The CHOOSE and RULE optimizer hints are no longer supported. The functionalities of those hints still exist but will be removed in a future release.
Existing applications that previously relied on rule-based optimization (RBO) need to be moved to query optimization.

HTH
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 28 2004
Added on Mar 31 2004
#general-database-discussions
1 comment
235 views