Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i dbms_stats.gather_database_stats() Benefits
>> In Oracle 9i on a Solaris 8 system can someone please explain what the
>> benefits of gathering database stats are?
Having up to date statistics available on all the objects of the database, allows Oracle to choose the best execution plan for a given query.
HTH -g Received on Wed Jan 11 2006 - 08:33:31 CST
![]() |
![]() |