Kbase P133360: SQL Query with left outer join and inner join runs slowly
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/08/2008 |
|
Status: Unverified
SYMPTOM(s):
SQL Query with left outer join and inner join runs slowly
Query takes much longer than expected to run.
The query plan for the slow query shows the inner join starting from the larger table.
FACT(s) (Environment):
Query returns correct results
Same results are returned immediately when the inner join is replaced by a derived table.
The query plan for the fast query using the derived table shows the inner join starting from the smaller table.
Windows
OpenEdge 10.1C
CAUSE:
Bug# OE00172547
FIX:
As a workaround, use the form of the query containing the derived table.