Ryan Marcus

EXPLAIN Yourself! Finding Query Planner Stalls Across DBMSes

It is found that although the queries triggering slow planning are largely DBMS-specific, recurring pathologies involving correlated subqueries, CTE expansion, repeated subquery expressions, disjunctive joins, and constant folding affect multiple systems.