Thread: Optimizing queries that use temporary tables

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 about:

- I can create indexes on this temp table to optimize queries ?

If yes...
- This indexes will be destroyed together (automatic?) the temp table
when the connection is closed ?
- When I insert a lot of new rows, need to run analyze on this temporary
table ?

Thanks in Advance.

--
Luiz K. Matsumura
Plan IT Tecnologia Informática Ltda.

On Jan 22, 2008 1:32 PM, Luiz K. Matsumura <luiz@planit.com.br> 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 add to the same temporary table.
>
> I have some questions that I'm concerned about:
>
> - I can create indexes on this temp table to optimize queries ?

Yes

> If yes...
> - This indexes will be destroyed together (automatic?) the temp table
> when the connection is closed ?

Yes

> - When I insert a lot of new rows, need to run analyze on this temporary
> table ?

Yes