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

$group using index

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor - P4
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Aggregation Framework
    • Labels:
      None

      Description

      It would be great for a $group stage to use indexes for easy group.

      For example, this aggregation

      [
      		 
      {
      		 
          $group: {
      		 
              _id: "$media",
      		 
              count: {$sum:1}
      		 
          }
      		 
      },
      		 
      {
      		 
          $sort: {
      		 
              count: 1
      		 
          }
      		 
      },
      		 
      {
      		 
          $limit: 10
      		 
      }
      		 
      ]

      is not using the "media" index.

        Attachments

          Issue Links

          duplicates

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-4507 aggregation: optimize $group to take advantage of sorted sequences

          • Major - P3 - Major loss of function.
          • Open
          related to

          Bug - A problem which impairs or prevents the functions of the product. SERVER-21471 Bad index selection on aggregate with $match + $sort

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

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              bappr Benjamin Appréderisse
              Participants:
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: