Re: More on dbms_stats

Anybody ever do the "analyze once and forget about it" I have moved to this because of posts like this. I was having too many problems with query performance when analyzing after every load (seems especially troublesome with bitmap indexes and partitioned tables). Some of my tables have > 100 million records and I have to wonder if 100 million records or 110 million records makes much difference to the optimizer.

Mike
----- Original Message -----
From: "Ana Choto" <achoto_at_american.edu>
To: <oracle-l_at_freelists.org>
Sent: Wednesday, August 10, 2005 2:56 PM Subject: More on dbms_stats

>
> Yesterday I posted a question regarding dbms_stats and analyze. A
> developer was running analyze compute on some tables because a report
> wouldn't run unless he analyzed compute statistics on those tables. I
> received great responses from the list, for which I'm really thankful.
The
> developer now is using dbms_stats and the report works just fine.
>
> The only thing is that he still has to run dbms_stats even after the daily
> job that gathers statistics finishes because the report doesn't work. I'm
> gathering schema stats with the following options:
>

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