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

[Steven Hawkins (Jira)]

     [ https://issues.jboss.org/browse/TEIID-5751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-5751:
----------------------------------
    Fix Version/s: 13.1
                       (was: 13.0)


> 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
>            Priority: Minor
>             Fix For: 13.1
>
>
> The issues came up in the following discussion
> https://developer.jboss.org/message/989502#989502
> > 1a) Are the constraints (indexes, foreign keys) now used to optimize queries in materialized tables or not?
>  
> 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.13.8#713008)