Re: Partial Analyze bad?

From: Ken Rachynski <krachyn_at_cadvision.com>
Date: Wed, 03 Mar 1999 09:33:05 -0700
Message-ID: <36DD6440.5078297D@cadvision.com>

David,

Thanks for the reply. Fortunately, my database is still rather small. I guess I'll schedule an analyse for one evening this week and see what happens.

David Lane wrote:

> The optimiser definitely gets confused when only some of the tables are
> analysed .... it's worth analysing all of your tables at the beginning,
> then you can do so many each day to keep things up-to-date
>
> Dave Lane (dlane_at_pt.lu)

--
Ken Rachynski
Database Analyst
krachyn_at_cadvision.com
<http://www.cadvision.com/krachyn>
ICQ: 3113514 Received on Wed Mar 03 1999 - 10:33:05 CST