Kbase 20573: What is the Difference Between On-line and Off-line Index Fix.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
What is the difference between on-line and off-line index fix.
FACT(s) (Environment):
Progress 8.x
Progress 9.x
FIX:
The level of fix between on-line and off-line index fix are the same.
- The only difference is the ability for off-line index fix to enable an index once it is determined that the disabled index is error free.
- There is also the potential of reporting discrepancies between the index scan and the database scan for the on-line index fix since the database can be changing in parallel with the on-line index fix. This does not indicate index corruption or a failure in the integrity of the index.