> would be much quicker as
>
> select myTable.myField LEFT JOIN AnotherTable on myTable.MyField = AnotherTable.myField where AnotherTable.PK IS NULL
The reason of this thread is because this was not optimized. Once I changed it to the LEFT JOIN, it works really fast.