Which provides better performance? Using a outer join where column is null or NOT EXISTS.
This is to retrieve records in a table where it exists in one table but not the other.
Printable View
Which provides better performance? Using a outer join where column is null or NOT EXISTS.
This is to retrieve records in a table where it exists in one table but not the other.
NOT EXISTS will be faster as OUTER JOIN needs to scan both tables and discard not matching records.