Re: silly dbms_stats question
Date: Sat, 25 Apr 2009 07:11:47 -0700 (PDT)
> dba_tables column "last_analyzed" does not reflect dbms_stats.
Could it be that your tables are partitioned and were analyzed with ANALYZE command before? See Note:258687.1 "Last_analyzed Column Does Not Change After Analyzing tables"? Mixing ANALYZE with DBMS_STATS actually has other problems as well.
Yong HuangReceived on Sat Apr 25 2009 - 09:11:47 CDT