Re: Temp space used by ANALYZE command

You are right. If you are using COMPUTE STATISTICS option then the temp table will run out of space. There are 2 ways to go with it 1.You can either use estimate statistics 2.Create a large temp tablespace (eg: large_temp) for this operation (100-200 or more ) depending on your tables & size) & let your batch script do this at off peak time (may be at night) alter user username temporary tablespace large_temp; analyze table t1 compute statistics;
analyze table t2 compute statistics;
alter user username temporary tablespace temp (or the temp tablespace for your schema)
Idea is to use this large temp. tablespace only for this purpose . I have used the 2nd methd successfully for my schema Prab Athilat
prab.athilat_at_fmr.com

John Bechtel <john.bechtel_at_teldta.com> wrote in article <33160E52.2B88_at_teldta.com>...
> I'm looking for any information about how much temp space is used during
> an ANALYZE TABLE command. I would like to run many simultaneous ANALYZE
> commands, but fear I will run out of temp space if several large tables
> are being analyzed at the same time.
>
> Any/all information will be helpful and appreciated.
>
> - John Bechtel
>
  Received on Fri Feb 28 1997 - 00:00:00 CST