Kbase P87103: Can I create a new index and make it the primary index with no recompilation ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/8/2004 |
|
Status: Unverified
GOAL:
Can I create a new index and make it the primary index with no recompilation ?
GOAL:
Does changing the primary key on a table forces to recompile ?
FACT(s) (Environment):
Progress 9.1x
FIX:
Creating a new index and having it being the primary key does not forces to recompile, the old .r files with static queries stores the index name of the original primary key, so, as long as this index is still available this code is valid and will run with no need to recompile it.
If .r code exists which uses dynamic queries , that code will take advantage of the newly created index.