Vineet Garg created CALCITE-3952: ------------------------------------ Summary: Improve SortRemoveRule to remove Sort based on rowcount Key: CALCITE-3952 URL: https://issues.apache.org/jira/browse/CALCITE-3952 Project: Calcite Issue Type: Improvement Components: core Reporter: Vineet Garg Assignee: Vineet Garg
If a query is guaranteed to produce maximum one row it is safe to remove Sort (along with limit). Example: {code:sql} select count(*) cs from store_sales where ss_ext_sales_price > 100.00 order by cs limit 100 {code} Although logically equivalent this can greatly benefit physical plans by removing extra operator and avoiding unnecessary data transfer. -- This message was sent by Atlassian Jira (v8.3.4#803005)