Kbase P99374: SQL-92: Prepared statements execute slower with parameters than with hard coded values.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/03/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Prepared statements with parameters produce different query plans than with hard coded values.
Prepared statements with parameters read a different number of records than with hard coded values.
Prepared statements execute slower with parameters than with hard coded values.
SQL-92
CAUSE:
Bug# 20041228-027
FIX:
Upgrade to Progress 9.1E01, OpenEdge 10.0B02, OpenEdge 10.1A or later.