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

Allow distinct to use indexes

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: 1.6.1
    • Fix Version/s: 1.7.3
    • Component/s: Index Maintenance, Querying
    • Labels:
      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

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

                Dates

                Created:
                Updated:
                Resolved: