[jira] [Commented] (CALCITE-4557) Sort costing should account the number of sort keys: the more keys to compare, the more the cost

[ https://issues.apache.org/jira/browse/CALCITE-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326130#comment-17326130 ] Julian Hyde commented on CALCITE-4557: -- {quote}I don't think it is necessary to simplify{quote}

[jira] [Commented] (CALCITE-4557) Sort costing should account the number of sort keys: the more keys to compare, the more the cost

[ https://issues.apache.org/jira/browse/CALCITE-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326073#comment-17326073 ] Haisheng Yuan commented on CALCITE-4557: But if "hiredate" is not in the output columns, or not

[jira] [Commented] (CALCITE-4557) Sort costing should account the number of sort keys: the more keys to compare, the more the cost

[ https://issues.apache.org/jira/browse/CALCITE-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326069#comment-17326069 ] Haisheng Yuan commented on CALCITE-4557: I don't think it is necessary to simplify "ORDER BY

[jira] [Commented] (CALCITE-4557) Sort costing should account the number of sort keys: the more keys to compare, the more the cost

[ https://issues.apache.org/jira/browse/CALCITE-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326067#comment-17326067 ] Julian Hyde commented on CALCITE-4557: -- A useful optimization would be to remove sort fields that

[jira] [Commented] (CALCITE-4557) Sort costing should account the number of sort keys: the more keys to compare, the more the cost

[ https://issues.apache.org/jira/browse/CALCITE-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17325482#comment-17325482 ] Haisheng Yuan commented on CALCITE-4557: {quote} I doubt that a 5-key sort is significantly

[jira] [Commented] (CALCITE-4557) Sort costing should account the number of sort keys: the more keys to compare, the more the cost

[ https://issues.apache.org/jira/browse/CALCITE-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17310474#comment-17310474 ] Vladimir Sitnikov commented on CALCITE-4557: (quote}Most likely, they all terminate in 1 or

[jira] [Commented] (CALCITE-4557) Sort costing should account the number of sort keys: the more keys to compare, the more the cost

[ https://issues.apache.org/jira/browse/CALCITE-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17310306#comment-17310306 ] Julian Hyde commented on CALCITE-4557: -- I doubt that a 5-key sort is significantly more expensive