TT vs Workfile
Differences:
* Workfiles can't have indexes on them, TTs can
* Workfiles are memory only
* TTs use as much memory as specified by the -Bt client parameter and then overflows to disk
* TTs are new, Workfiles are older
* TTs can be used by Proxygen and passed by handle in V9.1B
I'd go with TTs as they are much easier to use.
Hope that helps
Murray
PS Both are deleted when they go out of scope .. in V9 you can use empty temp-table ttxxx which is "really" fast