Steven Hawkins created TEIID-5531: ------------------------------------- Summary: Implicit indexing of common tables doesn't consider composite keys Key: TEIID-5531 URL: https://issues.jboss.org/browse/TEIID-5531 Project: Teiid Issue Type: Quality Risk Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 12.0 Using a common table that is referenced by a common predicate will create an implicit index, but only for the first attribute - in the case of a composite key a multi-column index will only be created if an array/row value comparison is used. For example: with (x) as (...) select (... from x where x.col1 = y.col1 and x.col2 = y.col2) ... from y should add an index on x using both col1 and col2. -- This message was sent by Atlassian Jira (v7.12.1#712002)