Kbase P32244: Will removing an inactive index on a 9.X database affect the
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/3/2003 |
|
Status: Unverified
GOAL:
Will removing an inactive index on a 9.X database affect the CRC calculation?
FACT(s) (Environment):
Progress 9.x
FIX:
- In Version 9.x of Progress the CRC was separated into table and index CRC.
- In version 9.x, only applications that use a changed index must be recompiled.
In Version 9.x, indices are removed from the table's CRC calculation and given their own CRC values.
Once the applications are converted to Version 9.x and the database is migrated to Version 9.x, a change to the indices does not necessitate a recompilation of
applications because the table's CRC value is unchanged.
You can add temporary and intermittently active indices without changing the CRC and therefore without impact to applications that do not reference the indices.
At run time, the application index CRC values for the indices it references are compared to the index CRC in the database. If there is a mismatch, the application does not run and an error is issued.