Can IO be reduced further?

shawnwilson 2017-09-12 19:00:12

I added the "missing indexes" it suggested but the IO's actually went up instead. Looking to see if there is anything else that can be down to reduce IO's here. I tried taking the subquery out into into a #tmp table that didn't seem to help either.

RvRijbroek 2017-09-14 18:00:21
If I read it correctly the criteria on join object 6 you need function1 based on object6.

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.

Good luck.