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