Re: Optimizer hint <*+ RULE *> question

From: magjez <magjez_at_yahoo.com>
Date: 7 Nov 2005 08:31:36 -0800
Message-ID: <1131381096.070157.255100@g14g2000cwa.googlegroups.com>

I also found at the following site that ANSI Outer joins will force the CBO: http://www.jlcomp.demon.co.uk/faq/force_cbo.html

I have a statement of the form:

select A.field1,

          A.field2,
          A.field3,
          B.field1,
          B.field2

from A
left join B
on A.field3 = B.field3

If I change the statement to:

select A.field1,

          A.field2,
          A.field3,
          B.field1,
          B.field2

from A,B
where A.field3 = B.field3 (+);

I can force the RBO

--maggie Received on Mon Nov 07 2005 - 10:31:36 CST