Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Hints and RBO?

Re: Hints and RBO?

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Sat, 14 Oct 2000 12:33:39 +0200
Message-ID: <39E83683.7C9A6946@0800-einwahl.de>

Hi Bill,

"optimizer_mode = choose" will pick cost based optimization if a) at least one of the used tables has statistics b) or if there is a hint other than "rule".

That is the defined behaviour of the optimizer and it perfectly explains the effects you observed.

Martin Received on Sat Oct 14 2000 - 05:33:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US