Re: Performance

From: Joel Garry <joel-garry_at_home.com>
Date: 3 Jan 2003 16:46:10 -0800
Message-ID: <91884734.0301031646.1c5c76ad@posting.google.com>

Karsten Farrell <kfarrell_at_belgariad.com> wrote in message news:<kO2R9.1097$ro.88978581_at_newssvr17.news.prodigy.com>...

>
> 1. You didn't mention anything about which optimizer you're using ...
> though I hope it's the cost-based optimizer since you're at 8.1.7
> (instead of one of the older versions that had trouble with CBO). If
> your init.ora doesn't specify CBO, then the analyze will be for naught.
>

Unless of course the init.ora specifies CHOOSE, in which case a completely bogus analyze on any table can mess things up big time.

I would suggest ALTER SESSION SET OPTIMIZER_MODE=RULE to remove the potential problem for testing purposes.

--
@home is bogus.

Received on Fri Jan 03 2003 - 18:46:10 CST