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

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
  • Date: Fri, 5 Aug 2011 13:52:51 -0600

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.
>  

Other related posts: