On Mon, 7 Mar 2005 12:34:20 -0500, Khedr, Waleed <Waleed.Khedr_at_fmr.com> wrote:
> 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.
But if there is a gap, and it sure looks like you have demonstrated
it, then I'd much rather be running on an optimizer that will (at
least eventually) likely have this sort of thing fixed, even if it
isn't currently fixed. Part of the search for a smarter database is
the (never ending IME) search for smarter ways to use the database I
actually do have.
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 08 2005 - 03:52:58 CST
