多重条件嵌套查询语句的优化？

Question

SELECT *
FROM table1 t1
WHERE t1.pk <>
    (SELECT m1
     FROM table2@db1
     WHERE m2=
         (SELECT t3.pk
          FROM table3@db2 t3
          WHERE t1.pk=t3.pk));