查询sql语句，请问还能怎么优化索引，能够优化一下sql 谢谢！
select t2.min_id ,t3.out_nick,t1.sys_trade_id,replace(ifnull(t3.outer_id,'0'),'','0') outer_id ,5 seq_pay_time,sysdate() etl_dt
from (select out_nick,sys_trade_id from m_ecrp_cts_seq tt where seq_pay_time=5 group by out_nick,sys_trade_id) t1
join (select min(id) min_id , out_nick, count(out_nick) cnt from m_ecrp_cts_seq group by out_nick having count(out_nick) >=5 ) t2
on t1.out_nick=t2.out_nick
join m_ecrp_trade_ord_t t3
on t3.sys_trade_id=t1.sys_trade_id
and t3.out_nick=t2.out_nick
order by t3.out_nick,t3.outer_id
以下是表索引添加情况：
