The order of the document properties does not affect indexing.
You can verify this yourself by running this query:
db.people.find({LName: "abc"}).explain()
and then this query:
db.people.find({LName: "jkl"}).explain()
you should see that MongoDB will use the index in both cases (the property cursorshould be something like "BtreeCursor LName_1_FName_1").
source
share