Description
Yingyi Bu made the following observation. If the WHERE clause does not depend on the LET clause, the WHERE should be evaluated before the LET, and the results pruned. Similarly for LETTING and HAVING.
Attachments
Issue Links
For Gerrit Dashboard: MB-22142 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
71452,2 | MB-22142. Optimize sequencing of LET and predicate. | master | query | Status: MERGED | +2 | +1 |
73351,2 | MB-22142. Optimize sequencing of LET and predicate. | watson++ | query | Status: MERGED | +2 | +1 |