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@xxxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> 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: > -- //www.freelists.org/webpage/oracle-l