Can IO be reduced further?
Can you move this function to the where clause?
Because it only uses only object6.
Now the index on object6 is used twice.
And you get scans on object4.index1 and object6.index3
Also currently your not filtering on object3/1
you could try moving it to the front.