Pushdown LIMIT in cross product joins ------------------------------------- Key: TEIID-2370 URL: https://issues.jboss.org/browse/TEIID-2370 Project: Teiid Issue Type: Enhancement Components: Query Engine Reporter: Mark Addleman Assignee: Steven Hawkins Priority: Minor Fix For: 8.3 Pushdown LIMIT clause in cross product joins. Queries of form SELECT t1.a FROM t1, t2 LIMIT 10 Produce a plan like this: LIMIT 10 CROSS JOIN Access: SELECT t1.a FROM t1 LIMIT 10 Access: SELECT 1 FROM t2 LIMIT 10 See https://community.jboss.org/thread/220834?tstart=0 for a little more detail