Re: [HACKERS] subselect and optimizer

> > But this patch still didn't help for a simple join without a where
> > clause. The query plan says it uses two sequential scans, where 6.2.1
> > uses two index scans.
>
> But we didn't have subselcts in 6.2.1?

No, but in the more general case of a simple join over two tables
with fields with an index declared on them.

say: Select * from Trans, Spieler where
Spieler.spieler_nr=Trans.spieler_nr

Uses indices in 6.2.1, doesn't use them in 6.3.1 (two seq scans).

I just wanted to remind you, that these problems are not restricted
to subqueries, but seem to be a more general 'flaw' in 6.3.x .

Hope this helps.

Ulrich