Let’s take the field _id
, which is unique across the collection.
Does it make any sense to have any compound index where _id
is the prefix eg:
{
_id: 1,
A: 1
}
Would the index above be any more efficient than simply the index of:
{
_id: 1
}