For Oracle Please try

select clm_id
,SUM(clm_pd_amt) AS c_p_a
,MAX(r_date) AS ran_date
,MIN(clm_stat) AS c_stat
FROM i_mra.cbn
WHERE clm_stat in (5,8)
AND clm_type IN ('r', 'p')
AND svc_date between '20190101' and '20191231'
AND pd_date >= '20190101'
AND...

Ok...Thank's mr.gilamonster for u solution 😀

This a SQLPlan of Jurnal Query,But I don't include Data,i hope anybody give a solution 😀

I was Create A Index,but not give effect pepormance Database!!

Maybe my Index not good so can u Try to teach me how to index 3 tabel!