Re: DBMS_STATS compared to the analyze command: weird!

Cookie Monster wrote:

> As a point of interest we had a consultant from Oracle in for a few days to
> tune our 8.1.7 database on solaris and he told us NOT to use the DBMS_STATS
> package to analyze the scheme. He pointed to a number of bugs and problems
> and suggested we continue to use the analyze table method for statistic
> gathering (seems problems are resolved in later releases). I do this using
> a stored procedure. Maybe you want to consider that??
>
> Regards,
> Cookie.

I've seen no evidence that your consultant's advice is correct. Can you point to anything specific?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)