It seems that the more compound index I add to my collection it gets better to some point and then beyond that the more indexes the slower it becomes. Is this possible? If so why? EDITED: I am referring to…
I have a collection test, and a compound index on it with two fields db.test.createIndex({ i: 1, j: 1 }) When I execute following pipeline db.test.aggregate([{ $sort: { i: 1, j: 1 } }], { allowDiskUse: false }) it works…
A collection has an indexed involved field_A. But field_A is not required. So what happens if some documents do not have this field? Will the index still work for documents that do have this field?