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

Allow distinct to use indexes

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • 1.6.1
    • 1.7.3
    • Index Maintenance, Querying
    • None

    Description

      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.

      Attachments

        Issue Links

          is depended on by

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-2094 distinct cheat with indexes

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-29244 CLONE - distinct cheat with indexes

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: