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.