Allow distinct to use indexes

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Done
    • Priority: Major - P3
    • 1.7.3
    • Affects Version/s: 1.6.1
    • Component/s: Index Maintenance, Querying
    • None
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      db.ensureIndex(

      {x:1}

      )

      db.distinct('x')

      Distinct apparently does a full table scan, even though it could use the index to speed things up a bit. Please see the discussion here:

      http://groups.google.com/group/mongodb-user/browse_thread/thread/912fd4b9e303fb04/

      My current application of MongoDB relies on fast distincts, and I think this would help quite a bit.

              Assignee:
              Eliot Horowitz (Inactive)
              Reporter:
              Kevin McCarthy
              Votes:
              9 Vote for this issue
              Watchers:
              9 Start watching this issue

                Created:
                Updated:
                Resolved: