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: why there is cost when I am running with RULE hint or optimizer_goal=RULE

Re: why there is cost when I am running with RULE hint or optimizer_goal=RULE

From: Hemant K Chitale <hkchital_nospam_at_singnet_nospam.com.sg>
Date: Tue, 21 May 2002 22:01:36 +0800
Message-ID: <acdkca$lp5$1@clematis.singnet.com.sg>

Do you have a Hint in the query ?
Do you have parallelism (DEGREE > 1) on any of the Tables in the query ? Is the query really running in RULE (maybe you have a login.sql which does an ALTER SESSION SET OPTIMIZER_MODE='CHOOSE') ?

Hemant K Chitale

"dro" <d.rodri_at_consultant.com> wrote in message news:d983391a.0205201226.3548039b_at_posting.google.com...
> Hi
>
> I have this problem, I run a pretty big query under choose and rule
> and both shows costs in explain plan. I thought in RULE we dont see
> costs whatsoever?
> Also under RULE the explain plan shows hash join but then again I
> thought hash join can only be used in CBO?
>
> Am I missing something?
Received on Tue May 21 2002 - 09:01:36 CDT

Original text of this message

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