Cost-Based or Rule-Based?

From: <dave_dizon_at_hotmail.com>
Date: Fri, 22 Jan 1999 08:37:16 GMT
Message-ID: <789dbs$b0n$1@nnrp1.dejanews.com>

As Oracle has been saying, Cost-Based is now and the future for database optimization. When I attended a presentation sponsored by Oracle, the presentor announced that all new Oracle customers know only of Cost-Based optimizer and that Oracle do not recommend new customers to implement Rule- Based.

So I am curious,how many installations out there are using or planning to use the Cost-Based Optimizer (CBO) instead of the Rule-Based Optimizer (RBO)? And for those who have the experience on both of RBO and CBO which is the better of the two?

I'd appreciate your input as my shop is planning to install Oracle 8 and we are currently deciding to design some new applications with either RBO or CBO consideration. Thanks!

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 22 1999 - 02:37:16 CST