Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1321

In-list to join optimization should have configurable in-list size

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.9.0
    • None
    • None

    Description

      We current have a default in-list size of 20. Instead of the magic number 20, we should make this configurable.

      select count(*) from table where col in (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);

      Attachments

        Issue Links

          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-350 SqlToRelConverter.getInSubqueryThreshold() can it be configurable?

          • Major - Major loss of function.
          • Closed
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. DRILL-3710 Make the 20 in-list optimization configurable

          • Major - Major loss of function.
          • Closed

          Activity

            People

              gparai Gautam Parai
              gparai Gautam Parai
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: