Difference Between Temp Table & Work Table

I might note that for many years work-tables have been deprecated since one could do anything with a temp-table that one could do with a work-table, but not vice-versa. In the last couple of years, though, we have come to realize that temp-tables may be overkill for some functions since a temp-table will use a minimum of 9 blocks for an empty table where a block is 1-8K depending on -tmpbsize. So, work-tables are getting a bit of a second look.
 
You must log in or register to reply here.
Back
Top