On Tue, 10 Feb 2004, CSN wrote:
>
> I disabled enable_hashagg and enable_nestloop. Appears
> to have made both queries worse :(
>
Good, then we know that the nest loop and hash agg are probably good
plans.
>
> How exactly do I do that?
>
> SELECT * from thanks limit 1000
> ;)
it's an alter table thingie:
alter table tablename alter column columnname set statistics 100;
But since it looks like it's picking a good plan, it's probably not a real
big deal.
So, can you get rid of the join / in on the other table, or do you need
it there?