RE: Portable DBA: Oracle
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Dec 2004 09:44:25 -0600
Without looking, doesn't estimate_percent >50 cause a compute? I remember it
did on ANALYZE, but I don't remember with DBMS_STATS...
Rich
-----Original Message-----
Sent: Thursday, December 09, 2004 9:26 AM
Subject: Re: Portable DBA: Oracle
Freeman Robert - IL wrote:
> Thanks Dwayne! Hope you like it!
>
> It's funny.... after I finally get a copy of a new book in my hands, I
> always see something I missed. For example, it just irks me that in my
> example of the use of dbms_stats.gather_table_stats that I don't include
> cascade=>TRUE in the example.
>
Don't feel too bad about this one. IMHO, cascade=>FALSE (the default) is
the right choice, especially if you use estimate_percent of less than
100%. Then follow with an explicit gather_index_stats with a full
compute. And any histograms also with a full compute.
--
Regards
Wolfgang Breitling
--
//www.freelists.org/webpage/oracle-l
Other related posts:
