[teiid-issues] [JBoss JIRA] (TEIID-3466) Selectivity is over estimated in joins with multiple predicates.

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-3466.
-----------------------------------
    Resolution: Done


Updated the costing logic to effectively ignore optional criteria and changed the cost estimate for and predicates using an average of high and low.  However this means that the estimate is not quite consistent as it can be slightly different based upon the order of the criteria, or can be different if computed as individual nodes rather than a conjunct.

> Selectivity is over estimated in joins with multiple predicates.  
> ------------------------------------------------------------------
>
>                 Key: TEIID-3466
>                 URL: https://issues.jboss.org/browse/TEIID-3466
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: Query Engine
>    Affects Versions: 8.0
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.11
>
>
> Selectivity is over estimated in joins with multiple predicates.  This is partial due to optional predicates discovered during copy criteria and partially due to always using the independent estimate of selectivity.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)