Query optimization on large table - Temporary tables ?

Hi all,

I happened to receive a big PL/SQL code to mantain, that does something like the following:

• Loop through a long list of customer records
  • For each customer record, copy a few records from a huge table (100 million records aprox.) to a temporary table (not Oracle 8i's temp table, just a regular table)
  • Run two heavy queries on these records
  • Write some stuff to another table, if necessary

Therefore, my questions are:

• Is there a point in copying the records from the big table to a temporary one ? These records are accessed through primary key.
• Would using Oracle 8i temporary tables instead of regular tables improve the performance somehow ?

Thanks in advance,

Marcos Pinto

   marcosc_at_gmx.de Received on Mon Mar 03 2003 - 13:14:54 CET