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

Build the SBE plan for $search with ID lookup

    • Type: Icon: New Feature New Feature
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 7.2.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Query Execution
    • Fully Compatible
    • QE 2023-07-24, QE 2023-08-07, QE 2023-08-21, QE 2023-09-04, QE 2023-09-18
    • 162

      PlanStageSlots: {kResult: output_doc, kMetadataSearchScore: searchScore_metadata}
      
      nlj  searchScore_metadata, output_doc, output_id
      left
           search_cursor_stage mongot_doc [output_id = “_id”, searchScore_metadata = “searchScore”, ...] firstBatchSlot cursorIdSlot hostAndPortSlot
      right
          limit 1
          nlj  output_doc, output_record_id
          left
              ix_scan input_index_key, {"_id": 1}, output_record_id
          right
              scan input_record_id, output_doc 

            Assignee:
            zixuan.zhuang@mongodb.com Zixuan Zhuang
            Reporter:
            zixuan.zhuang@mongodb.com Zixuan Zhuang
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: