Kbase P20784: How much slower is an index rebuild without sorting?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/8/2008 |
|
Status: Verified
GOAL:
How much slower will an Index rebuild be if I don't use sorting?
GOAL:
What can performance improvement can you use if you can't use sorting?
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
We haven't got exact numbers on how this will effect performance and each case will be different. We can say there will be a substantial difference that would be worth avoiding if possible.
If you can't use sorting for some reason (normally not enough disk space) it is suggested that you make the -B for the command as large as possible.