Re: Using TEMP Tables

David Chan (dwc@cix.compulink.co.uk) wrote: : > Any extra overhead when dropping the table? : Creating and dropping table does have an overhead so you should only do : it once per session i.e. don't drop and recreate within an application, : use delete instead. I disagree about the deleting of rows. If you have a TEMP table with a thousand rows in it, its is far quicker to discard it than to DELETE each row. -- ---------------------------------------------------------------------------- "...so does this jelly mean we don't have to do foreplay?" ----------------------------------------------------------------------------