Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: FIRST_ROWS(n) with nested queries

Re: FIRST_ROWS(n) with nested queries

From: srivenu <srivenu_at_hotmail.com>
Date: 11 Feb 2004 21:45:14 -0800
Message-ID: <1a68177.0402112145.32a8a95@posting.google.com> 





I think it is materializing the inline view in the second case before
it gets to the outer query.


This is the reason why the HASH JOIN is being used in the second case.
In the first case, it is sufficient if it gets the first 20 rows, so
it is using INDEX SCAN DESCENDING and getting the first rows according
to the order.


regards


Srivenu
Received on Wed Feb 11 2004 - 23:45:14 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US