I've mentioned this indirectly before, but can't find a log of it on the Web PTS, so I thought it might be worth mentioning again. I'd like to be able to create indexes on temp tables in SAPDB, i.e:-
CREATE temp.mytable ( acol INTEGER ) CREATE INDEX myind on temp.mytable(acol) or CREATE INDEX temp.myind on temp.mytable(acol) etc Both Oracle and Informix are able to do this and it was recently added to DB/2 (v8.1). Since temporary tables can get quite large then it would be a nice performance enhancement to support indexes as well. Hopefully this request can be put forward for consideration in a future version of SAPDB. Thanks in advance. David _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
