Major Description
ANSI OUTER JOIN to ANSI INNER JOIN transformation is a standard query rewrite functionality supported in most relational databases. Such transformation can potentially increase query performance dramatically, especially for large queries. One example, MB-29565, the query times out after 20+ min in Vulcan. With ANSI OUTER JOIN to ANSI INNER JOIN transformation the same query finishes in < 8 seconds.
Attachments
| For Gerrit Dashboard: MB-29712 | ||||||
|---|---|---|---|---|---|---|
| # | Subject | Branch | Project | Status | CR | V |
| 94844,2 | MB-29712 Support ANSI OUTER JOIN to ANSI INNER JOIN transformation | master | query | Status: MERGED | +2 | +1 |