Re: Index on temporary table?

Yes, it's possible... Your error has nothing to do with the fact that the table is temporary... You probably have some PREPAREd statements on the table done before the index creation.... If possible delay them to after the CREATE INDEX... Regards. On Mon, Aug 23, 2010 at 4:52 PM, Wyza, Jonathon <wyzaj@bethelcollege.edu>wrote: > 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. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --0016e64bb7c2e002c9048e7fb90f