Long runtime in a select with outer join
[full outer join] [join] [left outer join] [Outer] [outer join] [performance] [query] [rewrite] [Select] [sql outer join] [View]
Symptom
A long runtime occurs in a select with outer join. The executing transaction may terminate due to a timeout.
Other terms
Outer join, join view, select, performance, query rewrite
Reason and Prerequisites
1. You use MaxDB Version 7.6 or 7.7.2. The affected SELECT statement is an OUTER JOIN in which at least one of the two tables is a [...]