Tom Lane wrote on 24.08.2006 20:47:
Perhaps an extremely smart optimizer could improve this using knowledge of the specific aggregates' behaviors, but for "black box" aggregates it sounds pretty unworkable.
I don't know how they do it, but those functions in Oracle are pretty fast. Usually ways faster than some equivalent combinations of self joins, outer joins and such.
Thomas
