[
https://issues.apache.org/jira/browse/CALCITE-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17310306#comment-17310306
]
Julian Hyde commented on CALCITE-4557:
--------------------------------------
I doubt that a 5-key sort is significantly more expensive than a 1- or 2-key
sort. Most likely, they all terminate in 1 or 1.1 comparisons on average.
I would like to hear other people's opinions, or better, see some numbers,
before we make this change.
> Sort costing should account the number of sort keys: the more keys to
> compare, the more the cost
> ------------------------------------------------------------------------------------------------
>
> Key: CALCITE-4557
> URL: https://issues.apache.org/jira/browse/CALCITE-4557
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.26.0
> Reporter: Vladimir Sitnikov
> Priority: Major
>
> Current costing for sort does not account for the number of keys in the
> comparison function which might result in worse plan selection.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
