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

FInd using a boxed match causes full index scan

XMLWordPrintableJSON

    • Type: Icon: Question Question
    • Resolution: Done
    • Priority: Icon: Trivial - P5 Trivial - P5
    • None
    • Affects Version/s: None
    • Component/s: Querying

      If I run this find query:

      db.data.findOne({G:/^[W]/})

      I get a full index scan being performed.
      explained as :

         "indexBounds" : {
           "G" : [
                   "[\"\", {})",
                   "[/^[W]/, /^[W]/]"
           ],

            Assignee:
            sam.kleinman Sam Kleinman (Inactive)
            Reporter:
            paul.reed Paul Reed
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: