Re: Using TEMP Tables

Posted in 1995

"David Chan" — Sun, 14 May 1995 21:03:23 GMT — source: Informix-list mailing list archive (1991-1998)

> ... unless your temporary table has a lot of rows in it, in which case > the overhead of DROPping/CREATEing is probably more acceptable than > waiting for the DELETE to complete. This is true if you have thousands of rows however it does cause problems if you have prepared or declared any cursors to that temp table. > Regards, > Kerry S > BTW: America's Cup, America's Cup... :-) Congratulations. It's about time someone else won it. David W Chan Objective Research Ltd dwc@cix.compulink.co.uk