Kbase P68941: Is the value of index-num important within Oracle schema holder?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
Is the value of index-num important within Oracle schema holder
FACT(s) (Environment):
Oracle DataServer
FIX:
The following tests show that the value of index-num is not of importance.
Have "name.r" as the compiled version of the following 4GL program
FOR EACH customer BY name:
DISPLAY name.
when connected to a schema holder with customer##name having INDEX-NUM 3 and customer##country_post having INDEX-NUM 1.
See the results of executing "RUN name.r" with different schema holders.
1. a schema holders with index-num 1 for customer##name and index-num 3 for customer##country_post
The index hint given to Oracle is still customer##name.
2. a schema holder with index-num 1 for customer##name and no index-num 3
The index hint given to Oracle is still customer##name.
3. a schema holder with no reference to the customer##name index
The execution fails with error: Unable to locate index 'NAME' on table 'CUSTOMER' for procedure 'NAME.r'. (7967).