RE: Last_Analyzed appears to be incorrect

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 2 May 2005 10:54:10 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F87D5B@irvmbxw02>

Are you saying
analyze table ... for table
Or
analyze table ... for table for all indexes ? Because in that case you will not be creating histograms on the columns and the last_analyzed column will not change in user_tab_columns.
-----Original Message-----

Smith, Ron L.

I run an Analyze estimate on all my tables and indexes every weekend. But for some reason the LAST ANALYZED column of USER_TAB_COLUMNS indicates the tables and indexes have not been analyzed in a year. This is Oracle 7.3.4.

--

http://www.freelists.org/webpage/oracle-l Received on Mon May 02 2005 - 13:58:32 CDT