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

[CQF] Omit shard filtering stage when query has an equality predicate on the shard key

XMLWordPrintableJSON

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 7.2.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Query Optimization
    • Fully Compatible
    • QO 2023-09-04, QO 2023-09-18

      We can omit shard filtering when the query contains an equality predicate on all fields of the shard key because all documents are guaranteed to be owned by this shard.

      We can modify the implementer for SargableNode to perform this optimization when the node is being optimized with RemoveOrphansRequirement.

            Assignee:
            ben.shteinfeld@mongodb.com Ben Shteinfeld
            Reporter:
            ben.shteinfeld@mongodb.com Ben Shteinfeld
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: