Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-15279

Disable hash-based index intersection (AND_HASH) by default

    • Type: Icon: Task Task
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • 2.6.5, 2.7.7
    • Affects Version/s: None
    • Component/s: Querying
    • Labels:
      None

      Performance testing has suggested that hash-based index intersection, implemented by the AND_HASH query execution stage, does not offer a significant performance advantage for test workloads. This is due in part to SERVER-12923, which describes how query optimization can suffer for plans that are not fully pipelined.

      Based on the results of this testing, we should disable hash-based intersection by default. It will be possible to re-enable AND_HASH at run time via:

      db.adminCommand({setParameter: 1, internalQueryPlannerEnableHashIntersection: 1});
      

      Sort-based intersection will be on by default and will not be affected by this change.

            Assignee:
            david.storch@mongodb.com David Storch
            Reporter:
            david.storch@mongodb.com David Storch
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: