Kbase P87193: What is a Temp Table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/17/2009 |
|
Status: Verified
GOAL:
What is a Temp Table?
FIX:
Temporary tables (or Temp Table) are database tables that Progress stores in a temporary database. You define temporary tables as you do work tables. Unlike work tables, temporary tables have indexes and perform at the speed of regular database tables. Unlike regular database tables, which are permanent and which multiple users can access simultaneously, temporary tables last only for the duration of the procedure that defines them (or for the duration of the Progress session, if you make them GLOBAL), and allow only one user at a time to access them. Finally, temporary tables are private, visible only to the user (process) that creates them. In short, if you want to sort, search, and process data for a duration not longer than the Progress session, use temporary tables.
Progress stores temporary tables and temporary files in the same directory¾by default, your current working directory. You can change this directory by using the Temporary Directory (-T) startup parameter.
Temporary tables require less memory than large work tables. The Buffers for Temporary Tables (-Bt) startup parameter allows you to set the size of the buffer that Progress uses to control temporary tables. For more information on the -Bt parameter, see the Progress Startup Command and Parameter Reference.
NOTE: You cannot access temporary tables using SQL statements.