Michael42 wrote:
> Hello,
>
> In Oracle 9i on a Solaris 8 system can someone please explain what the
> benefits of gathering database stats are?
>
> I am asking in relation to using dbms_stats.gather_database_stats() .
> I have heard it can make DML more efficient and add information to OEM
> (total records) but was hoping to get a more detailed answer.
>
> Thanks very much,
>
> Michael42
The cost based optimizer uses statistics gathered by DBMS_STATS to make
decisions. Usually ... the better the quality of information provided to
the optimizer the better the quality of the decisions it makes. I'd let
the books written by Jonathan Lewis on the topic be your guide here.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Jan 11 2006 - 11:45:50 CST
