Re: ANALYZE
From: Christopher E. Justice <cjustice_at_erols.com>
Date: 1996/10/20
Message-ID: <01bbbe40$9559df20$a06a60cf_at_justice>#1/1
Date: 1996/10/20
Message-ID: <01bbbe40$9559df20$a06a60cf_at_justice>#1/1
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
> --
>
Received on Sun Oct 20 1996 - 00:00:00 CEST