Re: Cost- vs. Rule-Optimizer

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Sat, 21 Aug 1999 22:23:57 +1000
Message-ID: <7pm75c$pdo$1@m2.c2.telstra-mm.net.au>

One thing that sometimes works well to make the CBO do things right is to do an
ANALYZE TABLE XYZ FOR ALL INDEXED COLUMNS. Undocumented in V7, works fine there and later I believe.

I've had a few SQLs that I just couldn't get fast at all with the CBO, hints or no hints. They worked fine with the RBO. Using this ANALYZE, the CBO picked its socks up and all was fine.

HTH --
Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
Is there a nospam domain?
http://www.users.bigpond.net.au/the_Den

Jill <jc_va_at_hotmail.com> wrote in message news:7pm07r$j5a$1_at_bgtnsc02.worldnet.att.net...
> The CBO is not perfect. I pretty much test every SQL I write and use the
> appropriate hint. If they do away with the RBO, which I doubt, mgmt will
> just have to buy bigger and faster hardware.
>
Received on Sat Aug 21 1999 - 07:23:57 CDT