Re: Temporary tables

> Is it better to select into a temp table or create a temp table, prepare the > select and then use an insert cursor to populate it? I've seen some responses on this, and I think they all mentioned that it may be just ever-so-slightly faster to select into temp than to create a temp table and insert into it. However, I don't think anyone has pointed out that you probably DON'T want to use an INSERT cursor. This would imply that you also had a SELECT cursor which you used to select all the data from the server to your client, and then an INSERT cursor to put it all back into the temp table. This would be much less efficient than either SELECT...INTO TEMP or CREATE TEMP TABLE/INSERT INTO...SELECT FROM. -- June ---- June Tong Informix Software ---- ---- Senior Consultant (650) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Menlo Park ----