That is a perfectly legit question to ask a DBA.
"R Chin" <rchin_at_panix.com> wrote in message
news:a6lt28$gst$1_at_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 Wed Mar 13 2002 - 13:58:45 CST
