Index on temporary table?

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