Re: help with Analyze!!

From: Buck Turgidson <jc_va_at_spamisnotcool.hotmail.com>
Date: Sat, 07 Apr 2001 11:50:30 GMT
Message-ID: <aaDz6.24395$Ho5.7031460@typhoon.southeast.rr.com>

You could also analyze only those tables that don't have stats, to save you some time. You'd have to generate a script to do it.

"GC" <assistant_madman_at_hotmail.com> wrote in message news:3ACCF0C6.167A9047_at_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 Sat Apr 07 2001 - 06:50:30 CDT