Re: Temporary tables in memory

On 29 Aug 2003 02:05:12 -0700, chris_jack_at_msn.com (Chris Jack) wrote:

>Sybase returns result sets directly by just issuing queries from a
>stored procedure - PL/SQL uses other mechanisms like ref cursors. The
>problem arises because the method used to port the Sybase queries to
>Oracle was to store the results in a temporary table.
...
>So putting my head in the lions jaw... Sybase is typically configured
>to store its temporary database (Oracle would probably call this a
>tablespace) in memory. It gets away with this by recreating the
>temporary database from scratch every time the server is restarted.

There are techniques in PL/SQL (particularly in 9i) where you can load a table into an in-memory array of records for fast processing. But if the application is expecting to just run a regular query, I don't know a way to feed that data to it without putting it in a table first.

John

--
Photo gallery: http://www.pbase.com/john_russell/