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

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/07/12
Message-ID: <ibuomss8fgj5ab6lgsa8ntqp6v9f2e0962@4ax.com>#1/1

Look in the DBA_TABLES view (or ALL_TABLES or USER_TABLES), and look at the LAST_ANALYZED column. For indexes, look in DBA_INDEXES. Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Tue, 11 Jul 2000 16:52:05 +0100, "Keith Jamieson" <jamiesonk_at_phoenix.ie> wrote:

>Which table or view do I need to look in to find out when a table or index
>was last analysed.
>
>TIA
>
>Keith
>
Received on Wed Jul 12 2000 - 00:00:00 CDT