Kbase 19825: Stop Compiler Selecting Inactive Indexes With -noinactiveidx on Tru64
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/10/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.3C01
Compaq Tru64
SYMPTOM(s):
Index <index-name> is inactive and cannot be referenced. (995)
CAUSE:
When compiling source code, Progress selects indexes using an algorithm to select the most appropriate index to be used in a query. The algorithm makes no distinction between active and inactive indexes. Consequently, making an index inactive does not prevent the Compiler from selecting it at compile time.
FIX:
To allow the developer greater flexibility when deciding which indexes should be used, an additional client startup parameter (-noinactiveidx) has been created to prevent the compiler from selecting inactive indexes. When you start a client session with this parameter, the compiler is forced To select only active indexes when compiling source code. This does away with the need to delete an index from the database when you try to control which indexes are selected by the Compiler.