On Jan 22, 2008 1:32 PM, Luiz K. Matsumura <luiz@xxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
