Re: Analyze not working properly in 7.3.4

From: Paul Baumgartel <paul.baumgartel_at_gmail.com>
Date: Mon, 2 May 2005 16:16:56 -0400
Message-ID: <f8c477105050213163b638d5@mail.gmail.com>

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-l

Received on Mon May 02 2005 - 16:21:21 CDT