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

Are the estimates for the plan accurate? This is key to having properly sized workareas, etc.

See Randolf's post on hash aggregation and workareas: http://oracle-randolf.blogspot.com/2011/01/hash-aggregation.html

> From: ChrisDavid.Taylor_at_ingrambarge.com
> To: greg_at_structureddata.org
> CC: oracle-l_at_freelists.org
> Date: Fri, 5 Aug 2011 18:50:57 -0500
> Subject: 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_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-l
>
>
                                               

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