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 |