Reduce more logical reads

sqlmega 2014-09-19 20:23:05

How can I reduce the logical reads on the attached query?

tjosh52 2014-09-19 20:30:59
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.
Kevin 2014-09-22 18:47:52
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