Cherie,
Great name.
Our initial stats were generated with the ANALYZE
command. We did export all the stats with the
dbms_stats - one parameter of the GATHER_TABLE_STATS
procedure is CASCADE, which picks up the index and
column stats too. Please test first on your own system
to make sure this is
Jack,
Were your old statistics generated with the ANALYZE command? If yes, were
you able to export ALL of the old statistics with the export option of
DBMS_STATS before you actually analyzed with DBMS_STATS for the first time?
If yes, after exporting them, did you delete the old statistics usi
I've used 1 month ago on Oracle817 without any
problem.
--- [EMAIL PROTECTED] a écrit : > Hi
>
> Can anyone give feedback good or bad on the
> dbms_stats feature of
> exporting statistics. Is there any gotcha's or does
> it work well
>
> Cheers
>
>
> --
> ==
We just used it with great success to test our new
analyze strategy. You can label each set of stats, and
quickly switch between different analyze levels. Store
your old stats first and you can always fall back if
necessary.
Jack
--- [EMAIL PROTECTED] wrote:
> Hi
>
> Can anyone give feedbac
Hi
Can anyone give feedback good or bad on the dbms_stats feature of
exporting statistics. Is there any gotcha's or does it work well
Cheers
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.
