It's recommended that DBMS_STATS be used in place of ANALYZE,
depending on your version - let the db decide what needs to be
analyzed, how much data to look at, how many buckets and so on.
> Run the ANALYSE command to bring the statistics up to date. Run the
> analyse frequently enough to keep them up to date. I notice that the
> people I work with always re-analyse everything once per day. Don't know
> if its recommended anywhere, but that's what they do.
Received on Mon Apr 22 2002 - 09:24:51 CDT
