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: ROWNUM & server performance

Re: ROWNUM & server performance

From: ORA600 <panandrao_at_gmail.com>
Date: 12 Nov 2005 01:37:02 -0800
Message-ID: <1131788222.031910.109200@g49g2000cwa.googlegroups.com> 





Hi,



Read Tom Kyte's 'Effective Oracle by Design' and it has 3-4 pages
filled with ROWNUM optimisation methods and the very useful COUNT
STOPKEY feature when using ROWNUM 



cheers


anand
Received on Sat Nov 12 2005 - 03:37:02 CST












Original text of this message













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