Module decorrelate_predicate_subquery 

DecorrelatePredicateSubquery converts IN/EXISTS subquery predicates to SEMI/ANTI joins

Structs

DecorrelatePredicateSubquery

Optimizer rule for rewriting predicate(IN/EXISTS) subquery to left semi/anti joins

SubqueryInfo 🔒

Enums

SubqueryPredicate 🔒

Functions

build_join 🔒

build_join_top 🔒

Optimize the subquery to left-anti/left-semi join. If the subquery is a correlated subquery, we need extract the join predicate from the subquery.

extract_subquery_info 🔒

has_subquery 🔒

mark_join 🔒

This is used to handle the case when the subquery is embedded in a more complex boolean expression like and OR. For example

rewrite_inner_subqueries 🔒