[
https://issues.apache.org/jira/browse/CALCITE-3657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17009274#comment-17009274
]
Julian Hyde commented on CALCITE-3657:
--------------------------------------
What cost function do you propose to use? How do you address the intent of my
original comment?
{code:java}
// Cheaper if the smaller number of rows is coming from the LHS.
// Model this by adding L log L to the cost.
final double rightRowCount = right.estimateRowCount(mq);
final double leftRowCount = left.estimateRowCount(mq);
if (Double.isInfinite(leftRowCount)) {
rowCount = leftRowCount;
} else {
rowCount += Util.nLogN(leftRowCount);
}
if (Double.isInfinite(rightRowCount)) {
rowCount = rightRowCount;
} else {
rowCount += rightRowCount;
} {code}
> EnumerableHashJoin should not use NLogN for costing
> ---------------------------------------------------
>
> Key: CALCITE-3657
> URL: https://issues.apache.org/jira/browse/CALCITE-3657
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.21.0
> Reporter: Vladimir Sitnikov
> Assignee: Vladimir Sitnikov
> Priority: Major
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
