Home Forums SQL Server 2008 T-SQL (SS2K8) NOT IN query very expensive, 100% CPU RE: NOT IN query very expensive, 100% CPU
lrosales
SSCommitted
Points: 1821
More actions
September 11, 2012 at 1:20 pm
#1536453
Try using not exists(= boolean) instead of not in(= iteration) 🙂
"We never plan to Fail, We just fail to plan":)