Re: Oracle recordset paging

isepick wrote:

> I have read several techniques outlined in this group for recordset paging:
>
> 1) Using a temp table and identity column - insert ordered rows and return
> the appropriate rows
> 2) Using triggers.
>
> Has anyone used the second technique - using triggers to returned a page
> from a recordset ? I'm looking for real life experience out there since I
> find using a temp table very slow with a large amount of records, and the
> overhead of creating and destroying the temp table to be too much.
>
> I also can't use where rownum <= X and rownum >= y since it does not order
> the query first before assigning the rownum.
>
> Any suggestions on a better approach, or how to use triggers to perform
> recordset paging ?
>
> Thanks.

Never used a trigger and wouldn't consider it. Triggers should be avoided except in those few situation where they are the only solution to a problem. And those are few and far between.

Daniel A. Morgan Received on Sat Jun 16 2001 - 20:03:39 CDT