Re: list databases???

From: Sathish B <SathishRani_at_home.com>
Date: Fri, 11 May 2001 23:57:08 GMT
Message-ID: <o%_K6.4059$R5.738118@news1.rdc1.va.home.com>

Best way would be to create a procedure and schedule it in Cron , Dbms_jobs ............
But analyze only tables where data changed a lot . Dont analyze look up tables every day . If the tables are huge , do a estimate statistics 25% and analyze indexes alone .
Hope it helps
- Sathish B

"Galen Boyer" <galenboyer_at_yahoo.com> wrote in message news:u7kzok6bi.fsf_at_primix.com...
> On 9 May 2001, elufker_at_yagi.swcp.com wrote:
>
> > What is the best way to run analyze table????
>
> What do you mean? Syntax?
>
> --
> Galen
> I don't want to be the rock. Yeah, okay, what do you want to be?
> I want to be the piece of glass.
Received on Fri May 11 2001 - 18:57:08 CDT