I have an updateMany operation in which the query part is just are two fields, one a simple text field and the other a boolean field. Text field is indexed and the index is used properly in the query and everything is working. The only problem is that Examined:Returned Ratio is to high (aprox 6000) and I was wondering if adding the boolean field to index would improve the Ratio. I think so, and my next question is if should I do this or not, because I have read that boolean fields should not be indexed (as a regular rule). Performance is not an issue currently.
Query is the following:
updateMany({textField: "value", isField: true}. {$set: {isField: false}} )
The current index is: {textField: 1}