Hi,

It seems to be Missing index.

Solutions:Along with your query

Use Database Engine Tuning Advisor to get more clarity of recommendations .If U feel if it is really worth, Then test in...