Kbase P43656: Unexpected performance behaviour with SQL-92 queries including JOINS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/12/2009 |
|
Status: Unverified
SYMPTOM(s):
Adding an irrelevant statement to a query improves performance.
Query1: "JOIN table1 on table1.key = table2.key"
Query: "JOIN table1 on table1.key = table2.key WHERE table1.key = table2.key"
The Query2 is more efficient and reads less records than Query1.
FACT(s) (Environment):
Progress 9.1D
FIX:
None at this time