RE: Stop Criteria for Sql Execution

Optimizer=3DCHOOSE
Empty table no analyze!
No cost!
So probably it's not using cost based.

But this is another huge gap, who cares what mode we are using, it's an stop criteria.

No offense meant, but it's frustrating to get some simple stuff done!

Thanks Jonathan

Waleed

-----Original Message-----

From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk]=20 Sent: Monday, March 07, 2005 12:20 PM
To: oracle-l_at_freelists.org
Subject: Re: Stop Criteria for Sql Execution=20

Are you sure it was running cost-based when the FILTER was missing - I only put the hint in to show that I was running cost-based. A partitioned table will force cost-based, even in the absence of stats. (And, yes, it could be that 9.2.0.6 is just a little bit better at predicate tricks than 9.2.0.4).

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Public Appearances - schedule updated Jan 21st 2005

• Original Message -----=20 From: "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM> To: <oracle-l_at_freelists.org> Sent: Monday, March 07, 2005 5:16 PM Subject: RE: Stop Criteria for Sql Execution=20

The filter step did not show up in 9.2.0.4 without all_rows hint. It shows up only if the table is partitioned (even on another column).

Waleed

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 07 2005 - 12:37:38 CST