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: Pagination question

Re: Pagination question

From: <stevedhoward_at_gmail.com>
Date: 21 Apr 2006 07:00:03 -0700
Message-ID: <1145628003.874897.18490@z34g2000cwc.googlegroups.com> 





Hi Jacky,



When you say the "rownum usage for pagination in this kind sql is
useless", what do you mean?  I assume you are getting the correct data?
 You want the last 100 rows only (you said the first 100, but you order
the inner query desc), so that is what you are getting?  Is it "slow"?
How much I/O is it doing?



Regards,



Steve
Received on Fri Apr 21 2006 - 09:00:03 CDT












Original text of this message













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