You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In the present, the optimizer doesn't realize any information abount common expression.
This causes the Expression Evaluator to evaluate expressions repeatedly for every input tuple.
For Example:
> explain select x *2+ y, x *2+ y +4from test;
PhysicalProjection:
((InputRef #0 * 2) + InputRef #1)
(((InputRef #0 * 2) + InputRef #1) + 4)
PhysicalTableScan:
table #0,
columns [0, 1],
with_row_handler: false,
is_sorted: false,
expr: None
Maybe we should rewrite the plan to:
> explain select x *2+ y, x *2+ y +4from test;
PhysicalProjection:
(InputRef #0)
((InputRef #0) + 4)
PhysicalProjection:
((InputRef #0 * 2) + InputRef #1)
PhysicalTableScan:
table #0,
columns [0, 1],
with_row_handler: false,
is_sorted: false,
expr: None
The text was updated successfully, but these errors were encountered:
In the present, the optimizer doesn't realize any information abount common expression.
This causes the
Expression Evaluator
to evaluate expressions repeatedly for every input tuple.For Example:
Maybe we should rewrite the plan to:
The text was updated successfully, but these errors were encountered: