On Tue, Jul 22, 2003 at 18:39:33 +0200, Fabien COELHO <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
