Re: cost based optimizer vs rule based optimizer

From: <alanlee1_at_my-dejanews.com>
Date: 1998/06/22
Message-ID: <6mlpsq$c9c$1@nnrp1.dejanews.com>#1/1

CBO is normally the one to use but be careful with query with self-join especially with huge tables. If nothing works, try manual tuning with RBO.

Hope this helps.

Alan Lee
BSI In article <3576EE22.3AA6_at_creo.com>,
kbahi_at_creo.com wrote:
>
> Hi
> Does anyone have any opinions on which optimizer to use?
> Are they comparable? Is one always better than the other?
> Does it depend on the database ( volume, rate of change)
>
> Any info appreciated.
> BTW we are using oracle 8.0.3 under NT.
>
> Thanks
> Kel Bahi
> Creo Products
> kbahi_at_creo.com
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 22 1998 - 00:00:00 CDT