Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5751

Please add optimization support for foreign keys in materialized tables

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Minor
    • 13.1
    • 12.2
    • Query Engine
    • None
    • DV Sprint 60
    • 0.5

    Description

      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.  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, so it probably should be added.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            cjohn001 Christoph John (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 2 hours, 30 minutes
                2h 30m
                Remaining:
                Time Spent - 2 hours Remaining Estimate - 30 minutes
                30m
                Logged:
                Time Spent - 2 hours Remaining Estimate - 30 minutes
                2h