• ... and of course, you have a suitable (unique? clustered? as appropriate) index on ContractorCoverageException, like:

    ... ContractorCoverageException (contractorcoverageid, postalid)

    or

    ... ContractorCoverageException (contractorcoverageid) include (postalid)