Hi,
Can anybody let me know how I can optimise following Query.

Select * from reports
where
( exists ( SELECT 1 FROM results_require d rr, item_claims_tri als ict, results res
WHERE ict.t_t_id IN ( 3725 )
and res.rr_rr_id = rr.rr_id
AND rr.rt_rt_id = -1
and rr.ict_ict_id = ict.ict_id
and ( NVL( res.res_res_id_ refers_to, res.res_id ) = report_id )...