Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-8702

Incorrect example of query to show Index Intersection Mechanism

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major - P3 Major - P3
    • Server_Docs_20231030
    • None
    • manual, Server

    Description

      From documentation
      ...
      MongoDB can use the intersection of the two indexes to support the following query:

      db.orders.find( { item: "abc123", qty:

      { $gt: 15 }

      } )
      ...

      Based on that improvement and comment intersection should not work with range query. So the example should be like db.orders.find( { item: "abc123", qty:

      { $eq: 15 }

      } )

      Attachments

        Activity

          People

            Unassigned Unassigned
            dmytro.drachov@gmail.com Dmytro Drachov
            Votes:
            1 Vote for this issue
            Watchers:
            9 Start watching this issue

            Dates

              Created:
              Updated:
              1 year, 5 weeks, 6 days ago