how to make my sqls faster

Hi ,

We have below sql queries which runs daily, is there any suggestion to run these faster.

I appriciate your help.

update s_src_payment

set pay_stat_cd = 'Paid'

where par_payment_id in

(select bt_row_id from s_escl_req )

and ( payment_req_num like 'DF%'

or payment_req_num like 'RI%' )

 

update s_src_payment

set pay_stat_cd = 'Paid'

where row_id in

(select bt_row_id from s_escl_req )

and ( payment_req_num like 'DF%'

or payment_req_num like 'RI%' )

 

delete from s_escl_req

where bt_row_id