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