Re: Wow - has anyone used ROW_NUMBER() to get around using a UNION statement when UNION ALL doesn't work??
From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 5 Aug 2011 13:52:51 -0600
Message-Id: <65857EE5-361A-4BB4-B88C-644E3871FFF1_at_centrexcc.com>
Do you by chance have hash_group_by disabled - because of legacy code which expects group by to render rows in order without an explicit order by ?
Date: Fri, 5 Aug 2011 13:52:51 -0600
Message-Id: <65857EE5-361A-4BB4-B88C-644E3871FFF1_at_centrexcc.com>
Do you by chance have hash_group_by disabled - because of legacy code which expects group by to render rows in order without an explicit order by ?
In case the answer is yes, how does the union perform if you enable it for this session / sql ?
On 2011-08-05, at 1:30 PM, Taylor, Chris David wrote:
> My bad…appears it is a SORT UNIQUE.
>
> Some info for the UNION statement for those interested.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 05 2011 - 14:52:51 CDT