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

Dependent join back-off max ndv set to independent ndv estimate

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 12.2, 11.2.3, 12.1.1
    • None
    • Query Engine
    • None
    • Hide

      Set the cardinality value of the independent side table(s) to a higher value to allow the dependent join to proceed.

      Show
      Set the cardinality value of the independent side table(s) to a higher value to allow the dependent join to proceed.

    Description

      The search being used to find a max ndv for the independent side is just setting the result to be the original ndv estimate for the independent side. This results in unnecessary back-offs of performing the dependent join with a log message similar to:

      TEIID30011 Not performing dependent join using source $dsc/id0, since the number of distinct rows for expression g0.fkIdProductCode exceeds 1.333. You should ensure that your source statistics, including column distinct value counts, accurately reflect the source or use a MAKE_DEP hint to force the join.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: