Topic: Determination of mismatches of records
There are two tables with identifiers Table1 and Table2.
In them the miscellaneous at lines is constant and I need to compare them.
Help to understand as fastest to deduce the identifier list.
SELECT id FROM Table1 WHERE id not in (SELECT id FROM Table2)
Or all the same
SELECT id FROM Table1 WHERE not EXISTS (SELECT id FROM Table2 WHERE ID = Table1.id)
According to plan of request identical values, and on runtime that one another "benefits".