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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Slow PL SQL command LAST_RECORD

Re: Slow PL SQL command LAST_RECORD

From: Mike Burden <michael.burden_at_capgemini.co.uk>
Date: Mon, 19 Apr 1999 17:02:17 +0100
Message-ID: <371B5388.661F001F@capgemini.co.uk> 





If you are defining last to be the last row of a given sort key then the
only way to do this quickly without reading the whole table is define a
descending index (Oracle 8 I think) on the sort key and use this index
for the access path.



Svetlana Pelesheva wrote:



> Hi,


> How to go faster (than by LAST_RECORD) to the last record of a table.


>


> Thanks for the help.



Received on Mon Apr 19 1999 - 11:02:17 CDT












Original text of this message













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