[teiid-issues] [JBoss JIRA] (TEIID-5751) Please add optimization support for foreign keys in materialized tables

Christoph John created TEIID-5751: ------------------------------------- Summary: Please add optimization support for foreign keys in materialized tables Key: TEIID-5751 URL: https://issues.jboss.org/browse/TEIID-5751 Project: Teiid Issue Type: Enhancement Components: Query Engine Affects Versions: 12.2 Reporter: Christoph John Assignee: Steven Hawkins The issues came up in the following discussion https://developer.jboss.org/message/989502#989502   Pk, Unique Key, and Indexes on the view will result in the creation of an index on the materialization target table and are fully utilized in planning decisions.  Things are a little more complicated with foreign keys.  {color:red}Currently they are not propagated onto the generated materialization target table metadata, so they are only considered in pre-planner activities, such as rewrite, before the view reference is replaced with the materialization target - but there aren't meaningful optimizations being made at that time based upon foreign key.  There are couple of narrow situations where that information would be useful{color}, so it probably should be added. -- This message was sent by Atlassian Jira (v7.12.1#712002)