Hello All,

We propose to include a query optimizer called Table Pushdown which is a rule based optimizer and acts upon queries which satisfy the constraint that the query has a subquery within it and the outer table must have a join with the inner table specified in the subquery on a unique/Primary Key column of the outer table.

The following reference might be helpful-

The expectation is that by using this query optimizer, the run time can be reduced significantly for such queries thereby providing a significant advantage to the OpenLookeng engine's query processing capabilities.

Attached is the design document.

Please let me know if there are any review comments/suggestions.