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

In cursor.explain() documentation, define/explain "multi" in the "BtreeCursor <index> multi"

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

      The cursor.explain() somtimes shows:

      ...
      {
        "cursor" : "BtreeCursor _key1_1_key2_1 multi",
      ...
      

      The "multi" attribute at the end of the index doesn't seem to be documented. It refers to multiple ranges being used to scan the _key1_1_key2_1 index.

      For example, if the query condition includes "{key1:{$ne:5}}," the query optimizer might choose to search the index for two ranges:

        "indexBounds" : {
          "key1" : [
            [
              {
                "$minElement" : 1
              },
              5
            ],
            [
              5,
              {
                "$maxElement" : 1
              }
            ]
          ],
      

            Assignee:
            sam.kleinman Sam Kleinman (Inactive)
            Reporter:
            stephen.lee Stephen Lee
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:
              10 years, 44 weeks, 5 days ago