Answer
MongoDB can only use the initial fields of a compound index. If a query does not include the prefix field, the index cannot be used.
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ