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

[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: 
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.

  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.



> Improve with clause performance with incremental materialization
> ----------------------------------------------------------------
>
>                 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
>
>
> 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.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)