-
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
-
Originally Posted by paragp1981
Well size of these each tables is around 15-16 GB. So i cant really create
these temp table that will require huge space .
but if you run
(select sum(rated_volume)/60 from tnpostpaid.rtx_jul_aug
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|