Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: why there is cost when I am running with RULE hint or optimizer_goal=RULE
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
![]() |
![]() |