Re: help with Analyze!!

From: GC <assistant_madman_at_hotmail.com>
Date: Thu, 05 Apr 2001 22:18:29 GMT
Message-ID: <3ACCF0C6.167A9047@hotmail.com>

Glen A Stromquist wrote:
>
> I wrote a script to delete statistics, then do an analyze compute statistics
> on all of the tables in a schema. The anaylze failed on one table because
> the temp tablepace filled up.
>
> Performance is now so dismal the application is almost unusable, should I
> delete all of the stats from the analyze? I have to see if there is room to
> increase the temp tablepace so the analyze will run on the one table it
> failed on.

Keep the stats on the tables, and run 'analyze table_name estimate statistics sample 40 percent;' (or whatever percent of the table you can fit into the temp tablespace) on your larger tables.

Cheers,
GC Received on Thu Apr 05 2001 - 17:18:29 CDT