Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Analyze not working properly in 7.3.4
I dimly remember (after all, this release is over 10 years old!)=20
that, due to a bug, LAST_ANALYZED didn't get updated as it should. If
the statistics are OK, and your SQL is performing acceptably, that's
probably what's happening here.
--=20
Paul Baumgartel
paul.baumgartel_at_gmail.com
On 5/2/05, Smith, Ron L. <rlsmith_at_kmg.com> wrote:
> I run an Analyze estimate on all my tables and indexes every weekend.=3D2=
0
> But for some reason the LAST ANALYZED column of USER_TAB_COLUMNS as well
> as LAST ANALYZED in USER TABLES=3D20
> indicates that the tables and indexes have not been analyzed in a year.
> The statistics on each object appear to be correct.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 02 2005 - 16:21:21 CDT
![]() |
![]() |