Kbase 13792: Difference between a TEMP TABLE and WORK TABLE in Version 7
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Difference between a TEMP TABLE and WORK TABLE in Version 7
TEMP TABLE: WORK TABLE:
----------- -----------
(1) New to Version 7 (1) Included for backward
compatibility to Version 6
(2) Uses same indexing (2) No indexing
as associated db table
and you can define
others
(3) You can use the -Bt (3) Uses only available
startup parameter to memory
specify the temp table
buffer size
(4) Temp tables are stored (4) Work tables are stored
in the directory where in memory
other PROGRESS temporary
files are stored
In general we recommend that programmers use the Temp Table instead
of the Work Table, and use Work Table only when backward compatibility
to Version 6 is desired.
Users are referred to Chapter 13 in the 7.3A Programming Handbook for
more information.
Progress Software Technical Support Note # 13792