Re: Q: returning rows between two positions in a large query

From: Mark G <mgumbs_at_nospam.hotmail.com>
Date: Thu, 24 Jun 1999 09:09:25 +0100
Message-ID: <3771e55d.0@145.227.194.253>

No.

You create ONE temp table (or PL/SQL table) with all your data (700 records for example), sort the data in your prefered order and use the rownum method to obtain your row range. You use the same table when going from one page to another.

Mark

Y2K wrote in message <37710965.69216087_at_news.concentric.net>...
>Good suggestion. I still have a concern on performance. How big
>would the overhead be of creating temp tables each time a user goes
>from one page of 50 records to another one? Would it scale to a large
>number of users? I am new to Oracle, so pardon my naive questions.
>
>Thanks!
>
Received on Thu Jun 24 1999 - 03:09:25 CDT