Re: Select max within max

From: Geoff Muldoon <>
Date: Sun, 13 Jul 2008 09:31:26 +1000
Message-ID: <>

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

Original text of this message