really need index or refactor query the function1 in where clause

George Zhou 2017-03-06 19:51:04

Aaron Bertrand 2017-03-07 01:24:33
Really hard to provide definitive advice here, since the plan is anonymized (which just makes it hard to talk about specifics) and also because it seems to have been captured by Management Studio (or pulled from cache), which means it is missing all kinds of vital statistics. Could you capture an actual plan from within Plan Explorer, and post that? That can be anonymized too if it absolutely has to be, but it's easier to talk about your real entity names instead of trying to translate object3, index7, column32, etc. You can e-mail it to me at abertrand@sentryone.com if, again, it really must be anonymized.
Aaron Bertrand 2017-03-07 01:30:47
That all said, there seem to be a couple of easy wins highlighted in the plan. Add Column7 to Object6.Index7, and create an index on Object3 (Column8,Column6) INCLUDE (Column1,Column9).
George Zhou 2017-03-07 21:07:56
thank you Aaron, I appreciate this is real that I can post the plan and get help.
I will try to get the actual plan, it is on production server though.