Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temporary tables in memory
Comment in line
-- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html ____Finland__September 22nd - 24th ____Norway___September 25th - 26th ____UK_______December (UKOUG conference) Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html ____USA__October ____UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html "Chris Jack" <chris_jack_at_msn.com> wrote in message news:648c9f62.0309020109.644fc60d_at_posting.google.com...Received on Wed Sep 03 2003 - 08:32:49 CDT
> in PL/SQL and pushes the name CurrencyRS (a global temporary table)
on
> to a stack. The application then reads the table names off the stack
> one by one and does a table scan on each table - cleaning out the
> tables as it goes.
>
This 'cleaning out as it goes' may be the most significant part of the operation - is it done by deleting the rows from the GTT ? You might investigate the option for using an autonomous transaction to issue execute immediate 'truncate table GTT_TABLE' this would probably minimise the cost of cleanout.