Re: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work??
From: Taylor, Chris David <ChrisDavid.Taylor_at_ingrambarge.com>
Date: Fri, 5 Aug 2011 18:50:57 -0500
Message-ID: <38D36890-880B-4D0F-B582-2FD94734D54B_at_ingrambarge.com>
Greg, I didn't want to include all that in a general discussion on the list. I've got the plans, trace files and the tkprof outputs.
>
>
> --
> Regards,
> Greg Rahn
> http://structureddata.org
>
Date: Fri, 5 Aug 2011 18:50:57 -0500
Message-ID: <38D36890-880B-4D0F-B582-2FD94734D54B_at_ingrambarge.com>
Greg, I didn't want to include all that in a general discussion on the list. I've got the plans, trace files and the tkprof outputs.
I wanted to gauge interest primarily. Wolfgang, as an example, asked about HASH GROUP BYs. I'm not trying to solve a problem as much as discuss an interesting idea. So I wasn't sure what people might want to see AND not see.
Sent from my mobile device. Please ignore any typos or misspellings.
On Aug 5, 2011, at 3:40 PM, "Greg Rahn" <greg_at_structureddata.org> wrote:
> It would be extremely useful when talking about different plans to
> actually have the output from dbms_xplan.display.
>
> On Fri, Aug 5, 2011 at 1:15 PM, Taylor, Chris David
> <ChrisDavid.Taylor_at_ingrambarge.com> wrote:
>> >> Doh!
>
>
> --
> Regards,
> Greg Rahn
> http://structureddata.org
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 05 2011 - 18:50:57 CDT