Julian Hyde created CALCITE-556:
-----------------------------------
Summary: Ignore collation of columns not used as join or
aggregation keys in current query
Key: CALCITE-556
URL: https://issues.apache.org/jira/browse/CALCITE-556
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
Assignee: Julian Hyde
When collation trait is enabled (and similar traits such as
partitioning/clustering) the search space gets larger because each trait value
(e.g. order by x; order by x, y) causes a new subset. We could reduce the size
of the search space by ignoring the sort order of columns that are not used as
join, grouping, or sort keys anywhere in the query.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
