Re: ANALYZE

"Christopher E. Justice" <cjustice_at_erols.com> wrote:
>
>This function does more that just check the usage of a table. It also
>reorders the index of the table to achieve better performance. That is
 why
>you need more temporary space. I usually run this on a specific
 tablespaces
>when I notice a performance problem.
>
>TANDEM-TEAM <friedman_at_cais.com> wrote in article
><547p7p$ga5_at_news2.cais.com>...
>> I am using the ANALYZE table COMPUTE STATISTICS command to determine
 the
>> amount of disk space a very large table is using. The command
 apparently
>> needs lots and lots of temporary space. Two questions:
>> 1. Does anyone know why?
>> 2. Is there a way around this problem except to add data files to the
>> Temporary tablespace?
>>
>> Thanks

Analyze reorgs the index??? It's not written anywhere. I thought it's supposed only to collect stats an not to do any reorgs (but with Oracle you never know..).
The other question I have - does anybody there uses "validate structure" option with the analyze command? I need to get the number of blocks used by my indexes and it looks like I have to use validate stucture option for this.
Will it lock my table? (even if I use ESTIMATE STATISTICS?) Thanks,

   Yuri Received on Tue Oct 22 1996 - 00:00:00 CEST