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

Incorrect example of query to show Index Intersection Mechanism

    • Type: Icon: Bug Bug
    • Resolution: Won't Do
    • Priority: Icon: Major - P3 Major - P3
    • Server_Docs_20231030
    • Affects Version/s: None
    • Component/s: manual, Server
    • Environment:

      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 }

      } )

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

              Created:
              Updated:
              1 year, 25 weeks, 2 days ago