On Tue, Jul 22, 2003 at 18:39:33 +0200, Fabien COELHO <coelho@cri.ensmp.fr> wrote:
>
> As the resulting table is very small, I wish the optimizer would have
> skipped the sort phase, so as to aggregate the data as they come after the
> join. All may be done on the fly without much additionnal storage (well,
> with some implementation efforts). Maybe it is the "hash evaluation of
> group by aggregates" item listed in the todo list.
Yes the hash aggregate addition may help you. This has been implemented
in 7.4 which will be in beta shortly.