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
Printable View
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_augQuote:
Originally Posted by paragp1981
where r_p_contract_id=bm.co_id and
r_p_customer_id=bm.customer_id and
rtx_ent_date>=bm.act_date and
rtx_ent_date<=bm.end_date and
sncode=1 and call_type=1 and xfile_ind='H')
Then,
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.
Tamil