Re: Analyze Command

From: Konstantin Kivi <konst_at_sirena.rinet.ru>
Date: Wed, 2 Sep 1998 08:30:18 GMT
Message-ID: <EynEAI.23t.0.debian@sirena.rinet.ru>

GMAN <gman_at_siscom.net_NOSPAM> wrote:
> I agree with the other messages, with the understanding that the data is
> changing. The more frequently the data changes, large large, high volume
> OLTP, mass deletes, etc, the more frequently you should run Analyze...

In my opinion (get by expirience )
even single anylize (compute statistics) will almost stop "large large, high volume" OLTP system.

> My opinions are my own...

> George Spears

--
Sincerely Yours, Konstantin Kivi, Russia, konst_at_sirena.rinet.ru

aka <k-kivi_at_usa.net>, 2:5020/457.24_at_fidonet.org Received on Wed Sep 02 1998 - 03:30:18 CDT