Temp-table vs Work-table

[Joanna]

Could someone tell me the differences between temp-table and work-table? Will they be deleted automatically when the program ends?

Thank you very much for help!

 

[MurrayH]

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

 

[mra]

Most important I think, is that you can't use a work-table as a parameter to a procedure, only temp-tables.

regards
Mike