Re: Analyze not working properly in 7.3.4

From: Paul Baumgartel <paul.baumgartel@xxxxxxxxx>
To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 2 May 2005 16:16:56 -0400

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@xxxxxxxxx

On 5/2/05, Smith, Ron L. <rlsmith@xxxxxxx> 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

Follow-Ups:

Re: Analyze not working properly in 7.3.4
From: Jared Still

References:
- Analyze not working properly in 7.3.4
  - From: Smith, Ron L.

Re: Analyze not working properly in 7.3.4

Other related posts: