Re: Wrong results using decode when db upgraded to 9205

From: Daniel Fink <Daniel.Fink_at_Sun.COM>
Date: Wed, 05 May 2004 11:05:02 -0600
Message-id: <40991EBE.1C471491@sun.com>

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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed May 05 2004 - 12:12:45 CDT