Home Forums SQL Server 2014 Development - SQL Server 2014 Not Exist causing major performance problem RE: Not Exist causing major performance problem
Jason A. Long
SSC-Insane
Points: 23781
More actions
August 28, 2015 at 7:47 pm
#1823195
You can also get rid of the not exist altogether by doing a LEFT JOIN to ContractorCoverageException cce...
Then in the WHERE clause...
WHERE cce.contractorcoverageid IS NULL