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

yes... a composite partitioned table is involved, guess that was the problem

thank you

Thomas Kyte <tkyte_at_oracle.com> wrote in message news:<acdsb60173c_at_drn.newsguy.com>...
> In article <d983391a.0205201226.3548039b_at_posting.google.com>,
> d.rodri_at_consultant.com says...
> >
> >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?
>
>
> You are using some feature that forces CBO such as:
>
> o table with non-default degree of paralellism
> o partitioned table
> o index organized table
> ...
>
> or you might have a query with a hint in it.
Received on Tue May 21 2002 - 17:13:58 CDT