When looking at SERVER-97860, there are 2 workarounds and one of them is using hint() method:
https://jira.mongodb.org/browse/SERVER-97860
Workaround exists without upgrading the cluster:
Add a hint() to the affected query, which causes the fault path to be bypassed.
Alternatively the user can set the query knob internalQueryDisableSingleFieldExpressExecutor to true to turn off the fault path for all non-_id queries.
I would like to ask how we can use hint() method as a workaround. I’m not sure which index has to be specified in the method.
Do we have to specify the compound unique index described in the issue ?
OR
Do we have to specify another index that is not related to one described in the the issue ?
Thank you in advance,
Regards,
Cheeyoung