Description

this page says:

As a result of changes to sorting behavior on array fields in MongoDB 3.6, when sorting on an array indexed with a multikey index the query plan includes a blocking SORT stage. The new sorting behavior may negatively impact performance.

Since SERVER-31898 has been fixed, the situation now (4.4 and later) is that we may, under certain circumstances, use the index (instead of a blocking sort) to answer these queries.

Scope of changes

Impact to Other Docs

MVP (Work and Date)

Resources (Scope or Design Docs, Invision, etc.)