If the table A 20 million data

Table B 100000 data


How to improve the the following SQL?
Select * from table B where not the exists (where the select keywords from list A table b. field 1=table a. field 1)

CodePudding user response:

Stick the bai table structure and implementation plan