例如,下面的SQL,就是将not in改写为anti join的执行计划和耗时: teledb=# explain select * from t1 left outer join t2 on t1.f2 = t2.f2 where t2.f2 is null; QUERY PLAN ------------------------------------------------------------------------------------------------------------