Re: analyze command

From: Karl Hewlett <fake_address_at_auckland.ac.nz>
Date: 2000/04/14
Message-ID: <8d648u$fpj$1@scream.auckland.ac.nz>#1/1

look in dba_tables in oracle 8

Karl

Jerry Gitomer <jgitomer_at_erols.com> wrote in message news:20000414.4405300_at_noname.nodomain.nowhere...

Yes,

In Oracle 7 look in user_tab_columns. (Yeah, you certainly wouldn't expect to find it there, but it is). In Oracle 8 I believe it is in a more reasonable place, but I don't remember where.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/13/00, 6:44:18 PM, "Francis Wong" <wongfrancis_at_home.com> wrote regarding analyze command:

> Is there a way to find out when a table is analyzed last time?
Received on Fri Apr 14 2000 - 00:00:00 CDT