RE: Index on temporary table?

It is possible to index temporary tables, however, the temp table is still only visible to the session that created it, so if your script exits before you try to access it, the temp table will be gone. If your script is echoing a statement to dbaccess, then as soon as it exits, the temp table is gone. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Wyza, Jonathon Sent: Monday, August 23, 2010 10:53 AM To: ids@iiug.org Subject: Index on temporary table? [20999] Is it possible to create an index on a temporary table? I have a script that creates a temporary table worth of data and then does a great deal of selects and parsing of the data inside of it. I was thinking of putting an index on a few key columns in the table to speed it up but when I try I get the following message: execute failed: SQL: -710: Table (wyzaj.t_data) has been dropped, altered or renamed However the table definitely exists. I thought that it might need its statistics updated first, so I did a low & high update before I called the create index, but still the same response. Is it simply not possible? Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu> ============================== SLES 11x64 & IDS 11.50.FC6 "Don't document the problem, fix it." - Atli Björgvin Oddsson ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.