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.