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

More aggressively use enhanced join sorted index to prevent buffering

    Details

    • Type: Enhancement
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 10.0, 9.3.3
    • Component/s: Query Engine
    • Labels:
      None

      Description

      In some circumstances the cost of buffering the unsorted side to determine the applicability of the index is greater than simply using the index. The logic should also use a better estimate of the memory footprint of the index - which is only required to hold the depth of tree in memory at one time.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                shawkins Steven Hawkins
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: