[teiid-issues] [JBoss JIRA] (TEIID-4099) Improve with clause performance

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-4099:
----------------------------------
    Description: We should do more to analyze predicates to determine if the rows of the common table can be limited or if an index can be automatically added.  (was: When a with clause item is first referenced it is fully materialized before use.  We should generally allow iterative processing for full table scans - in scenarios where the table hasn't been augmented to add inferred indexes.

Another possible improvement to consider would be to fully analyse the predicates used against the common table to determine if a disjunct of all would limit the rows needed.)
        Summary: Improve with clause performance  (was: Improve with clause performance with incremental materialization)


> Improve with clause performance
> -------------------------------
>
>                 Key: TEIID-4099
>                 URL: https://issues.jboss.org/browse/TEIID-4099
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 10.0
>
>
> We should do more to analyze predicates to determine if the rows of the common table can be limited or if an index can be automatically added.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)