> create a index on (fieldA, fieldB) seam to no help too much (it's speed only the work on FieldA, but not on fieldB)

Drop this useless composite index and create two indexes one single
fields. i.e. index on fieldA and another index on fieldB.

SY, SD.