|
[oracle-l]
||
[Date Prev]
[05-2005 Date Index]
[Date Next]
||
[Thread Prev]
[05-2005 Thread Index]
[Thread Next]
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
|
|
