Techniques to improve query performance using dynamic filtering based on left-join aggregation pattern

A non-transitory computer-readable storage medium for tangibly storing computer program instructions capable of being executed by a computer processor, the computer program instructions defining steps of:

• receiving, by a query engine, a database query, the database query including an inner query having inner query conditions and an outer query having outer query conditions;
• determining, by the query engine, that a number of rows responsive to the outer query exceeds a threshold;
• determining, by the query engine, that the inner query conditions and the outer query conditions are correlated;
• rewriting, by the query engine, the inner query conditions to include at least one of the outer query conditions to generate an optimized query;
• and
• executing, by the query engine, the optimized query on a database.

A device comprising:

• a processor;
• and
• a storage medium for tangibly storing program logic for execution by the processor, the program logic comprising:
• logic, executed by the processor, for receiving a database query, the database query including an inner query having inner query conditions and an outer query having outer query conditions,
• logic, executed by the processor, for determining that a number of rows responsive to the outer query exceeds a threshold,
• logic, executed by the processor, for determining that the inner query conditions and the outer query conditions are correlated,
• logic, executed by the processor, for rewriting the inner query conditions to include at least one of the outer query conditions to generate an optimized query, and
• logic, executed by the processor, for executing the optimized query on a database.