Re: [PERFORM] Optimizing queries that use temporary tables

2008-01-22 Thread Scott Marlowe
On Jan 22, 2008 1:32 PM, Luiz K. Matsumura <[EMAIL PROTECTED]> wrote: > Hello, > > I'm developing some routines that will use temporary tables and need > advice on how to not lose performance. > > I will insert data in a temporary table and use this data to generate > new sets that will update or a

[PERFORM] Optimizing queries that use temporary tables

2008-01-22 Thread Luiz K. Matsumura
Hello, I'm developing some routines that will use temporary tables and need advice on how to not lose performance. I will insert data in a temporary table and use this data to generate new sets that will update or add to the same temporary table. I have some questions that I'm concerned abo