Tom Lane wrote:
Ole Langbehn <[EMAIL PROTECTED]> writes:

What do you think about the idea of an "UniqueSort" which would do
sort+unique in one pass ?

This is what oracle does and it is quite fast with it...

Hashing is at least as fast, if not faster.

regards, tom lane

I got good mileage in a different SQL engine, by combining the hash-aggregate and sort nodes into a single operator.
The hash table was just an index into the equivalent of the heap used for generating runs. That gave me partially aggregated data,
or eliminated duplicate keys, without extra memory overhead of the hash-aggregation node below the sort. Memory was scarce then ... :-)

BTW I'm really puzzled that Oracle is pushing 'index skip scan' as a new feature. Wasn't this in the original Oracle Rdb --- one of Gennady Antoshenkov's tweaks?

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to