Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: analyze

Re: analyze

From: Ilja Anikushin <aiv_at_strogino.ru>
Date: Sun, 18 Apr 1999 19:37:41 -0000
Message-ID: <7fcu8v$41r$1@ns.mtu.ru>


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 - 14:37:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US