sql - 需要加快这条SQL语句的结果。有什么建议吗？

Question

我有以下需要大幅加速的 SQL 语句。问题是我需要搜索两个字段，其中每个字段都调用多个子选择。有没有办法将这两个字段连接在一起，以便我只调用一次子选择？

SELECT billyr, billno, propacct, vinid, taxpaid, duedate, datepif, propdesc
FROM trcdba.billspaid
WHERE date(datepif) > '01/06/2009'
AND date(datepif) <= '01/06/2010'
AND custno in
 (select custno from cwdba.txpytaxid where taxpayerno in
  (select taxpayerno from cwdba.txpyaccts where accountno in
   (select accountno from rtadba.reasacct where controlno = 1234567)))
OR custno2 in
 (select custno from cwdba.txpytaxid where taxpayerno in
  (select taxpayerno from cwdba.txpyaccts where accountno in
   (select accountno from rtadba.reasacct where controlno = 1234567)))

Answer 1

我会使用连接而不是嵌入的子查询。