Reduce more logical reads
How can I reduce the logical reads on the attached query?
Your estimated rows and actual rows are way off. I would update stats on the involved objects and try to get rid of the index scan. Make sure that the clustered index covers the where clause. If it doesn't build a supporting index that does.
TJosh52's recommendations are good. Also, it looks like the table dbo.tblTerms code use non-clustered indexes on the Code and Term columns. That might get rid of some of the clustered index seeks. -Kev