Re: Analyze / Optimize

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 9 Jun 1999 07:05:43 +0200
Message-ID: <928904657.15318.0.pluto.d4ee154e@news.demon.nl>

This command only finds the chained rows, it doesn't analyze the table. Only compute|estimate statistics
return results in the dictionary.
Hth,

Sybrand Bakker, Oracle DBA

Van Messner wrote in message <8qh73.250$uw3.13752_at_typ32b.nn.bcandid.com>...
> If I 'analyze table X list chained rows into CHAINED_ROWS' , I get
row
>chaining information in table CHAINED_ROWS. I do not get any of the
>"analyze" columns filled in when I look at dba_tables (chain_cnt etc.)
> So I'm assuming that table X and its indexes were not analyzed. I
>further assume that the optimizer will not see table X as optimized. Is
>this correct?
>
>Thanks,
>
>Van
>
>
Received on Wed Jun 09 1999 - 00:05:43 CDT