这条sql语句如何进行调优，希望能运行快点

[hymarx]

delete from chd_lang_cash_mov_name
where batch_id = 778 and (trans_num, cash_mov_num) in
(select trans_num, cash_mov_num
from chd_lang_cash_mov_name
where batch_id = 778
minus (select trans_num, cash_mov_num
from chd_current_acct_mov_load
where load_id = 621))

表结构
chd_lang_cash_mov_name(batch_id,trans_num,cash_mov_num)
chd_current_acct_mov_load(load_id,trans_num,cash_num)
说明
chd_current_acct_mov_load 表很大，load_id=621可以有300，000条纪录

[boydgmx]

cenlmmx 的语法都有问题，居然也蹭分？？

[boydgmx]

delete from chd_lang_cash_mov_name a
where a.batch_id = 778
and not exists(
select 1
from chd_current_acct_mov_load b
where b.load_id = 621
and a.trans_num=b.trans_num
and a.cash_mov_num=b.cash_mov_num
);

[cenlmmx]

delete from chd_lang_cash_mov_name a
where a.batch_id = 778 and not exists
(select 1 from chd_current_acct_mov_load b
where b.load_id = 621 and a.trans_num=b.trans_num ,
a.cash_mov_num=b.cash_mov_num)

[cenlmmx]

呵呵,一模一样

[cenlmmx]

如果能在两个表的连接列trans_num,cash_mov_num上建个索引,可能还会好些

[hymarx]

谢谢各位，在chd_lang_cash_mov_name 加index(batch_id,trans_num,cash_mov_load_num)
问题已经解决