Re: analyze
From: Ilja Anikushin <aiv_at_strogino.ru>
Date: 1999/04/18
Message-ID: <7fcu8v$41r$1_at_ns.mtu.ru>#1/1
Date: 1999/04/18
Message-ID: <7fcu8v$41r$1_at_ns.mtu.ru>#1/1
select last_analyzed from user_tables where table_name='YOUR_TABLE_NAME';
info_at_skyiimax.com wrote in message <3719eee2.141960_at_usenet.psinet.com>...
>hi all,
>
>Does anyone know of a way to know when the last analyze on a table has
>been done ?
>
>
>Thanks in advance
>
>
>
Received on Sun Apr 18 1999 - 00:00:00 CEST