Re: ANALYZE

From: Kevin Loney <"75663,327"_at_compuserve.com>
Date: 1996/10/18
Message-ID: <3267D875.3D46_at_compuserve.com>#1/1


TANDEM-TEAM wrote:
>
> 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?

COMPUTE STATISTICS typically creates a temp segment up to 4 times the size of the analyzed segment.

> 2. Is there a way around this problem except to add data files to the
> Temporary tablespace?
>

You could use ESTIMATE STATISTICS, but the results are not as reliable as those generated via COMPUTE STATISTICS.

Kevin Received on Fri Oct 18 1996 - 00:00:00 CEST

Original text of this message