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

Implicit indexing of common tables doesn't consider composite keys

XMLWordPrintable

    • Icon: Quality Risk Quality Risk
    • Resolution: Done
    • Icon: Major Major
    • 12.0, 11.2.1
    • None
    • Query Engine
    • None

      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 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.

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: