> I'm also not sure how to handle this if the set has to be spooled to
> disk. Quicksort and Quickselect do a lot of scans throught he data and
> wouldn't perform well on disk.
I thing, so problem is in aggregate func used as window func - or some
missing optimalisation.
when I replaced count(*) over () by subselect (SELECT count(*) FROM
...) then I got expected speed.
Pavel
>
> --
> greg
> http://mit.edu/~gsstark/resume.pdf
>