Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-15054

Use statistics for joins

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • sql
    • None
    • Docs Required, Release Notes Required

    Description

      Optimize join selectivity estimation using collected underlying tables statistics. Mostly, it's about equals conditions on join: for common cases when tbl1.col1 = tbl2.col2 presented and statistics available for both columns - optimizer can use additional conditions like (col1.maxValue >= col2.minValue and col1.minValue <= col2.maxValue).

      For example: col1 contains numbers from 1 to 10 while col2 contains numbers from 1 to 100. So we can expect that only 10% of rows in tbl2 were selected.

      It's all just a hypothetical option to dig in.

      Attachments

        Issue Links

          Activity

            People

              Berkov Alexander Belyak
              Berkov Alexander Belyak
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: