RE: Native Hash Full Join and Pagination Query 11g

you've changed the order by since the original posting. which order by do
you actually want? a.actID versus c.name, a.actID

How do you want null values to sort for the sort order you actually want?

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Stalin
Sent: Tuesday, November 03, 2009 1:02 PM
To: Dion Cho
Cc: oracle-l
Subject: Re: Native Hash Full Join and Pagination Query 11g

No Luck there. Here is the revised Plan.

SELECT * FROM (
   SELECT tmp.*, rownum rnum FROM (
      SELECT /*+ opt_param('_optimizer_native_full_outer_join', 'off')
use_nl no_native_full_outer_join */ c.customerId, subscriberId, name,
city, phone1, email1, a.actId
      FROM Accounts a FULL JOIN Customer c ON a.customerid =
c.customerid ORDER BY c.name, a.actId
   ) tmp WHERE rownum <= 10
) WHERE rnum >= 1

<snip>



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


Other related posts: