The use or misuse of user-defined temporary tables can greatly affect the overall performance of Adaptive Server and your applications.
Temporary tables can be quite useful, often reducing the work the server has to do. However, temporary tables can add to the size requirement of tempdb. Some temporary tables are truly temporary, and others are permanent.
tempdb is used for three types of tables:
Truly temporary tables
Regular user tables
Worktables
