[ 
https://issues.apache.org/jira/browse/CALCITE-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17326073#comment-17326073
 ] 

Haisheng Yuan commented on CALCITE-4557:
----------------------------------------

But if "hiredate" is not in the output columns, or not used by parent 
operators, dropping "hiredate" may benefit us.

> 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)

Reply via email to