Re: Wrong results using decode when db upgraded to 9205
- From: Daniel Fink <Daniel.Fink@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 05 May 2004 11:05:02 -0600
Contrary to rumor, the RBO is alive and well in 10g (though
supposed to be on it's last legs).
Here is selected output from a trace file:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 -
64bit Production
<snip>
PARSING IN CURSOR #2 len=134 dep=0 uid=33 oct=3 lid=33
tim=1333462250010 hv=4175702228 ad='8d947228'
select /*+ rule */ p.name, t.synopsis, s.name
from p, t, s
where p.id = t.project
and s.project = p.id
END OF STMT
PARSE
#2:c=10000,e=8169,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=3,tim=1333462249984
In the PARSE #2 line og=3 means that the optimizer_goal is RULE
(og Optimizer goal: 1=All_Rows, 2=First_Rows, 3=Rule, 4=Choose )
QED, YMMV, IMHO, Yada Yada Yada...
Daniel
"Duret, Kathy" wrote:
>
> A question about using the Rule hint for new code?
>
> Forgive me, but isn't the rule going away in 10G and I would assume the rule
> hint would no longer work or rather be ignored in 10G so why put rule into
> new code to have to rewrite it when you migrate to 10G.
>
> Haven't tested it in 10G so I don't know for sure. Has anyone?
>
> Kathy
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
