Adaptive Server creates internal temporary tables for the session-assigned tempdb for merges, sorts, joins, and so on. These temporary tables are called worktables, and they:
Are never shared
Disappear as soon as the command completes
