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- https://15721.courses.cs.cmu.edu/spring2017/papers/15-optimizer2/a8-sen.pdf
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.
Thanks and Regards, Siddharth D Jaiswal