[teiid-issues] [JBoss JIRA] (TEIID-5751) Please add optimization support for foreign keys in materialized tables
Steven Hawkins (Jira)
issues at jboss.org
Thu Feb 27 17:12:01 EST 2020
[ https://issues.redhat.com/browse/TEIID-5751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins updated TEIID-5751:
----------------------------------
Story Points: 0.5
Sprint: DV Sprint 60
> Please add optimization support for foreign keys in materialized tables
> -----------------------------------------------------------------------
>
> Key: TEIID-5751
> URL: https://issues.redhat.com/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)
More information about the teiid-issues
mailing list