Details

    • Type: Improvement
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      The following optimization potential was identified within the benchmarks:

      1. Push FILTERs into the join operation (rather than applying them on top), in order to avoid materialization of unneeded results
      2. Inline non-equality FILTER expressions that do not require materialization
      3. Inline non-equality FILTER expressions that require materialization with prior materialization step
      4. Eliminate redundant application of already inlined FILTERS (cf. SP2B q6)

      5. Note that there are already mechanisms to inline FILTERs at access path iterator level (see IndexLocalFilter, AccessPathFilter as entry points).

      See also https://phabricator.wikimedia.org/T96094 for an example that bears optimization potential

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            bryanthompson bryanthompson
            Reporter:
            michaelschmidt michaelschmidt
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated: