Uploaded image for project: 'Engineering'
  1. Engineering
  2. ENG-5549

Query planner should be able to use more than One IN filters

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: V3.6
    • Fix Version/s: None
    • Component/s: Core
    • Labels:
      None

      Description

      Paul and I already have it in our plan to optimize the Index Usage. We may rewrite the index usage function.

      Implement as cartesian product of "materialized tables" joined to the indexed table.
      Add SQLCoverage coverage cases (test up to 3 IN clauses on different columns at once).
      Validate that we don't do anything WRONG if the columns are repeated in different IN clauses. ( X IN (...) AND X IN (... ) ), whether or not we optimize this case (as an intersected set).

      Save "OR" cases, including the same column "OR" case ( X in (...) OR X in (...) as another lower priority ticket (leave this as an unoptimized case).

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              xin Xin Jia
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:

                Zendesk Support