Re: strange plan

On 27 Jun 2001 01:28:03 -0400, Craig Longman wrote:
> 
> i've got two machines both with roughly the same database, one has a few
> more rows in some of the tables, but only about 2% more.  both databases
> have the same tables and the same indexes.  however, the slower machine
> seemed to be much slower than i would have expected it to be, so i
> started doing some looking, and found some very different and strange
> query plans.

i'm sorry.  i had been under the mistaken impression that the vacuumdb
command updated the table/index statistics.  i returned to looking
through the manual after sending the email and almost immediately
stumbled upon the 'vacuum analyze' command.  sigh.  it optimizes as
expected now and returns in a proportionate amount of time.

humbly,

-- 
   CraigL->Thx();   Be Developer ID: 5852