FInd using a boxed match causes full index scan

XMLWordPrintableJSON

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

      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 (Inactive)
              Reporter:
              Paul Reed
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: