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@xxxxxxxxxxxxxxx>
To: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
Date: Fri, 5 Aug 2011 18:50:57 -0500

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@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxx> wrote:
>> 
>> Doh!
> 
> 
> --
> Regards,
> Greg Rahn
> http://structureddata.org
> 

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work??
From: Dominic Brooks

References:
- Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work??
  - From: Taylor, Chris David
- Re: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work??
  - From: Wolfgang Breitling
- RE: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work??
  - From: Taylor, Chris David
- Re: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work??
  - From: Wolfgang Breitling
- RE: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work??
  - From: Taylor, Chris David
- Re: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work??
  - From: Greg Rahn

Other related posts:

» Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Taylor, Chris David
» Re: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Wolfgang Breitling
» RE: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Taylor, Chris David
» Re: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Wolfgang Breitling
» RE: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Taylor, Chris David
» RE: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Taylor, Chris David
» Re: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Greg Rahn
» Re: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Taylor, Chris David
» RE: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Dominic Brooks
» RE: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Taylor, Chris David
» Re: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Taylor, Chris David
» Re: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Taylor, Chris David
» Re: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Greg Rahn
» RE: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Mark W. Farnham
» Re: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Greg Rahn
» RE: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Taylor, Chris David
» Re: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Jeremy Schneider
» RE: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Mark W. Farnham
» RE: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work?? - Taylor, Chris David