still i think what slimdave is saying is true ub query is getin executed 52128446 times so i have asked developer to change login probabily going for cursor or some thing with bulk collect
(select sum(rated_volume)/60 from tnpostpaid.rtx_jul_aug
Originally Posted by paragp1981
where r_p_contract_id=bm.co_id and
sncode=1 and call_type=1 and xfile_ind='H')
To speed up the subquery create an index on
sncode, call_type, xfile_ind, rtx_end_date, r_p_customer_id , r_p_contract_id, rated_volume.
Also, post the view definition.
Click Here to Expand Forum to Full Width