Mihai Budiu created CALCITE-7093:
------------------------------------
Summary: DPhyp algorithm should accept cost model as parameter
Key: CALCITE-7093
URL: https://issues.apache.org/jira/browse/CALCITE-7093
Project: Calcite
Issue Type: Wish
Components: core
Affects Versions: 1.40.0
Reporter: Mihai Budiu
This is about the hypergraph-based optimization introduced in [CALCITE-6846] by
[~dongsl].
The algorithm makes calls to a cost model using getCumulativeCost() (function
chooseBetterPlan()); the cost model is obtained from the Rel nodes.
It could be useful to allow add to the the rule configuration an API to specify
a cost model, similar to the MULTI_JOIN_OPTIMIZE rule (LoptOptimizeJoinRule),
whose Config has as "withCostFunction" api.
For example, this would allow the algorithm to emulate bushy join optimization
using a cost model that optimizes for plan depth.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)