SQL queries-data that exists in one table and not in another

A, b two tables, find the ID field, there is a table, but there is no data in table B. A total of 13w data, after the deduplication of about 3W data, b table has 2W data, and B table ID field is indexed.

Method One

Easy to understand with not in, low efficiency ~ Execution Time: 1.395 seconds ~

Select distinct  from where  not inch (Select from B)

Method Two

Use left Join...on ..., "b.ID isnull" indicates a record of NULL in the b.ID field after you have connected-the execution time: 0.739 seconds ~

Select  from  Left Join  on a.ID=whereisnull

Method Three

Logic is relatively complex, but fastest ~ execution time: 0.570 seconds ~

Select *  from where (SelectCount(1as fromwhere==0 

SQL queries-data that exists in one table and not in another