Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Temporary table vs pl\sql table

Temporary table vs pl\sql table

From: Amihay Gonen <AmihayG_at_ectel.com>
Date: Wed, 30 Nov 2005 10:42:58 +0200
Message-ID: <5A841A20A9085A4C984EADD0FF97BF3707FED4@ectilex.ectel.com>


Hi , I've a process which need to do a lot of processing (summaries) on a large set of data.  

The main flow is as follow:  

   copy the new rows since last run (up to defined row count) to a temporary table.    Run various selects with group by on the temporary table and merge them into summary table.  

 I wander (I will conduct some tests ofcourse ) what type of temporary table will be better:   

  1. create ... temporary table or ...
  2. create type test is table of

The first option has more i/o and go throw the buffer cache , but doesn't consume a lot of memory the second option doesn't has I/O but consume more memory for the PGA.  

Any ideas ?      

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 30 2005 - 02:44:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US