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

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


Other related posts: