Re: Finding out when a table or index was last analysed

From: Keith Jamieson <jamiesonk_at_phoenix.ie>
Date: 2000/07/12
Message-ID: <8kha8i$i22$1@kermit.esat.net>#1/1

Thanks Guys, I am now half way there,
I have all the tables, ie

select distinct

           table_name,
           last_analyzed

   from user_tab_columns;

So can I find out if an Index has been analyzed. Oracle 7.3.4. on Windows NT. Received on Wed Jul 12 2000 - 00:00:00 CDT