Currently, this compound index is in increasing cardinality: locations.site-locations.path. This does not help in querying due to the large difference in cardinalities.
Instead, flip this compound index to be locations.path-locations.site, so we can query by locations.path.
The active MongoDB instance will need to be altered right before merge/publish/restart.
Currently, this compound index is in increasing cardinality:
locations.site
-locations.path
. This does not help in querying due to the large difference in cardinalities.Instead, flip this compound index to be
locations.path
-locations.site
, so we can query bylocations.path
.The active MongoDB instance will need to be altered right before merge/publish/restart.