[teiid-issues] [JBoss JIRA] Resolved: (TEIID-239) ENHANCEMENT: Costing beyond cardinality sould be propogated

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-239.
----------------------------------

           Labels: costing  (was: )
         Assignee: Steven Hawkins
    Fix Version/s: 7.4
                       (was: 8.0)
       Resolution: Done


Added logic to also set the column value estimates on each node.  This will improve set query and aggregate costing, but did not yet improve ndv nnv updates with joins.

> ENHANCEMENT: Costing beyond cardinality sould be propogated
> -----------------------------------------------------------
>
>                 Key: TEIID-239
>                 URL: https://issues.jboss.org/browse/TEIID-239
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 6.0.0
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Minor
>              Labels: costing
>             Fix For: 7.4
>
>
> Defect Tracker #24037: Currently values for ndv and nnv are recalculated at each plan node based upon the value at the physical layer.  This is not a good estimate.  Instead, these values should be propagated through the plan just like the cardinality and adjusted appropriately for join, unions, etc.  It may also be good to allow the use of costing metadata on virtual layers.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira