Question: I have analyzed my database
using dbms_stats but I don't know how often I need tore-analyze by
statistics. All of my execution plans are good, and I need
direction on the optimal frequency for re-analyzing dbms_stats for
table and indexes. What is the optimal interval for running
Answer: There is the old saying "if it
ain't broke, don't fix it", and so long as your tables
remain "stable", a single deep sample may be sufficient.
How often to reanalyze statistics depends upon two factors,
the time required to re-analyze the schema and he rate of
change of the schema data.
In sum, the optimal frequency for re-analyzing optimizer
statistics ids a function of the tale/index sizes and the
rate of change to the tables.
re_analyze tips and