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

query optimizer should consider full b-tree scans for certain queries

    • Type: Icon: Improvement Improvement
    • Resolution: Duplicate
    • Priority: Icon: Minor - P4 Minor - P4
    • None
    • Affects Version/s: None
    • Component/s: Querying
    • Labels:
      None
    • Fully Compatible

      on a query such as :

      > t.find(

      { q : /.*cde.*/ }

      ).explain()

      and other similar things, the query optimizer should consider using an index on

      { q : 1 }

      if it exists. the entire index would have to be scanned, but that will in some cases still be much faster than a table scan. (this is assuming a "covered index" approach - that iwll have to be verified too)

      i think a hint works with the above now?

            Assignee:
            Unassigned Unassigned
            Reporter:
            dwight@mongodb.com Dwight Merriman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: