Re: Select max within max
Date: Sun, 13 Jul 2008 09:31:26 +1000
Mladen Gogala says...
> And, if T1 has few thousand rows, it's going to be full table scan,
> window sort and sort distinct, in that order. In other words, the
> resource consumption will just explode. As this is obviously a report,
> materialized view looks like the only reasonable solution. This is a
> sort of "mad max" query.
Actually it will need to populate a cursor in a PL/SQL package.
GM Received on Sat Jul 12 2008 - 18:31:26 CDT