Jack,
7) GATHER_STALE
We just discussed this, is the MONITOR option set for all your tables? So
that DBA_TAB_MODIFICATIONS is populated and then DBMS_STATS can determine if
stats are stale. I know there is an article in Metalink that speaks to
this.
-Original Message-
Sent:
So Jack, if I'm reading between the lines correctly, you find
no reason to use DBMS_STATS prior to 9i?
My 8i databases are purrfectly happy with ANALYZE, and I'm
loathe to change something (that works) just to use the latest
and greatest. I don't like hemorrhaging out on the bleeding edge.