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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Rule Based Optimization

572601May 9 2007 — edited May 9 2007
Hi,

Rule Based Optimization is a deprecated feature in Oracle 10g.We are in the process of migrating from Oracle 9i to 10g.I have never heard of this Rule based Optimization earlier.I have googled for the same.But, got confused with the results.

Can anybody shed some light on the below things...

Is this Optimization done by Oracle or as a developer do we need to take care of the rules while writing SQL statements?

There is another thing called Cost Based Optimization...
Who will instruct the Oracle whether to use Rule Based Optimization or cost Based Optimization?

Thanks & Regards,
user569598

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 6 2007
Added on May 9 2007
#general-database-discussions
3 comments
182 views