Kbase P80707: General Guideline for determining what to set TPE_MM_SWAPSIZE environment variable to.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/01/2005 |
|
Status: Verified
GOAL:
General Guideline for determining what to set TPE_MM_SWAPSIZE environment variable to.
GOAL:
How to determine how large the temporary file will grow on disk when performing an update statistics.
GOAL:
How large can a temporary file be when using UPDATE STATISTICS?
GOAL:
What should I set TPE_MM_SWAPSIZE environment variable to?
FIX:
A formula does not currently exist to tell you what the size the temporary file can be when performing an UPDATE STATISTICS. However the following guideline may give a close approximation:
1. Dump the data definitions (.df) for the database
2. Add up all SQL widths of all columns for a table.
3. Then take the number from step 2 and multiply it by the number of records in the table.
This should give a close approximation.
For UPDATE INDEX STATS, the total SQL widths of the components should be used.