Re: Stop Criteria for Sql Execution

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 7 Mar 2005 17:20:22 -0000

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 is just a
little bit better at predicate tricks than


Jonathan Lewis
The Co-operative Oracle Users' FAQ
Public Appearances - schedule updated Jan 21st 2005

----- Original Message ----- 
From: "Khedr, Waleed" <Waleed.Khedr@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, March 07, 2005 5:16 PM
Subject: RE: Stop Criteria for Sql Execution 

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



Other related posts: