Just as a question to Tom and team,
I saw a post a bit ago, about plans for 8.4, and Tom said it is very
likely that 8.4 will rewrite subselects into left joins, is it still
in plans?
I mean query like:
select id from foo where id not in ( select id from bar);
into:
select f.id from foo f left join bar b on f.id=b.id where b.id is null;
the latter is most often much much faster on 8.1-8.3;
thanks.
--
GJ