Re: Using TEMP Tables

> > What is the overhead when in 4gl you "create TEMP table...", load it > with something, then "Drop" it? Same as any other table pretty much >Do temp tables take more overhead than a "permanent" table? No not really but you may want to avoid having it created in the root dbspace by specifying a tempdbspace. You also want to remember that a temp table is on a per user basis, so you may have more temp tables than you think. >Does it take longer to retrieve things from it? No longer than a permanent table of the same size > Any extra overhead when dropping the table? No more than a permanent table >We load an average of a couple hundred rows or less. >The size of the row is 2 char columns, total row size is 50. > > We are on SCO Unix online 5.01. > > Steve Goldberg > Landata RE-Source > goldberg@landata.com >