Kbase P105929: Oracle data server does not generate hint syntax in SQL with exclusive-lock and using query-tuning (
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/04/2006 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
Progress 9.x
OpenEdge 10.0A
OpenEdge 10.0B
SYMPTOM(s):
using query-tuning (HINT index....) statement does not generate index hint in SQL sent to Oracle
using query-tuning (HINT hint_syntax....) statement does not generate any hint syntax in SQL for Oracle
The query is a "FOR EACH" using exclusive-lock
FOR EACH statements using NO-LOCK or SHARE-LOCK produce hints in SQL
CAUSE:
Bug # 20050701-012
FIX:
Upgrade to 10.0B04 or 10.1A
If unable to upgrade then use the following workaround:
Use the USE-INDEX syntax instead of the query-tuning syntax in your FOR EACH statement. The index associated with the USE-INDEX statement will be used as an index hint by the Oracle DataServer when generating the SQL.