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

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

From: dro <d.rodri_at_consultant.com>
Date: 20 May 2002 13:26:51 -0700
Message-ID: <d983391a.0205201226.3548039b@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 Mon May 20 2002 - 15:26:51 CDT

Original text of this message

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