Hi all,
the following query issued via mongo shell returns the result instantly:
db.coll.find({}, { A:true, B:true, C:true}).hint('A_1_C_1_B_1').explain()
whereas the same query issued via PyMongo returns result in almost 10 minutes. I tried both forms of supplying the hint, no difference:
coll.find({}, { A: True, B: True, C: True}).hint('A_1_C_1_B_1').explain() # form 1
coll.find({}, { A: True, B: True, C: True}, hint='A_1_C_1_B_1').explain() # form 2
any ideas why is that and how to fix this issue?
PyMongo 3.10.1
MongoDB 4.4