Update taking time because of db file sequential read. - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Update taking time because of db file sequential read.

  1. #11
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    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

  2. #12
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Quote 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
  •  



Click Here to Expand Forum to Full Width