Re: ANALYZE

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?
> 2. Is there a way around this problem except to add data files to the
> Temporary tablespace?
>
> Thanks
> --

If all you need to determine is the current space usage of this table you could look the user_segments view.The bytes column of this view indicates the current disk usage for this table.

-- 

Regards,

Varad Acharya

 The above statements and opinions are my own and do not
 necessarily represent those of Ford Motor Company.