Re: Slow PL SQL command LAST_RECORD

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 19 Apr 1999 12:35:16 GMT
Message-ID: <371c22cb.1662700@192.86.155.100>

A copy of this was sent to Svetlana Pelesheva <pele_at_ttu.ee> (if that email address didn't require changing) On Mon, 19 Apr 1999 14:59:32 +0300, you wrote:

>Hi,
>How to go faster (than by LAST_RECORD) to the last record of a table.
>
>Thanks for the help.
>
>

Well, to go to the last_record you are causing all records to be fetched from the query and brought back to the client. You might try increasing the array fetch size for the block in question from 15 (i think thats what the default is) to something higher like 100.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Apr 19 1999 - 07:35:16 CDT