Re: Table Analysis Info

From: R Chin <rchin_at_panix.com>
Date: Tue, 12 Mar 2002 16:48:10 -0500
Message-ID: <a6lt28$gst$1@reader2.panix.com>

Hi Daniel, why you say so ?
It's just if I can find the RIGHT answer myself, why ask ? I just don't want to run into the Sybrand Baaker (RTFM !) Type of situation (Isn't he suppose to know this ? dumb developer !)

so does num_rows and LAST_ANALYZED of USER_TABLES give sufficient info ?

Thanks Robert

damorgan wrote in message
>But as a DBA I think you are taking the wrong approach: Go ask!
>Daniel Morgan
>
>
>R Chin wrote:
>
>> I don't want to ask the DBA about our table analysis practice
>> I'd like to find that out myself...
>>
>> How does one find that out ? Querying....
>>
>> USER_TAB_COL_STATISTICS
>>
>> That seems to be a big table(view), I issued the SQL 2 mins ago, and it's
>> still going...is there a faster way ?
>>
>> Thanks
>>
>> R Chin
>
Received on Tue Mar 12 2002 - 15:48:10 CST