[
https://issues.apache.org/jira/browse/CALCITE-832?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maryann Xue closed CALCITE-832.
-------------------------------
Resolution: Duplicate
> General optimization rules for Limit
> ------------------------------------
>
> Key: CALCITE-832
> URL: https://issues.apache.org/jira/browse/CALCITE-832
> Project: Calcite
> Issue Type: Improvement
> Reporter: Maryann Xue
> Assignee: Julian Hyde
>
> 1. LimitUnionRule:
> Rule that applies to a Limit on top of a Union. The original Limit won't
> go away after applying this rule, but additional Limit nodes will be created
> on top of each child of Union, so that these children produce less rows and
> Limit can be further optimized for children Rels.
> 2. LimitJoinRule:
> Rule that applies to a Limit on top of an *OUTER* Join. The original
> Limit won't go away after applying this rule, but additional Limit node(s)
> will be created on top of the outer-side child (or children if it's a FULL
> OUTER Join). This will have impact on the cost of modified child node(s) as
> well as that of the join node itself (among different join algorithms).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
