Select a. * from ods_new_big_warehouse a
Where the exists (select 1 from yibai_new_big_warehouse b where b.s ku=a.s ku and b.w arehouse_code=aleem walji arehouse_code);
The statement is executed 2 s

Select a. * from ods_new_big_warehouse a
Where not the exists (select 1 from yibai_new_big_warehouse b where b.s ku=a.s ku and b.w arehouse_code=aleem walji arehouse_code);
The statement execution 5 minutes are not

Two table data under 200 w

Excuse me each bosses, what's inside this optimization skills? thank you

CodePudding user response:

Two tables built table statements and index, all out,