DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 16

Thread: Deleting records takes long time and unltimately servers hang

Threaded View

  1. #4
    Join Date
    Oct 2006
    Posts
    175
    Code:
    Any suggestions or ulternatives how we can improve the time of this job?
    Your help will be greatly appreciated!
    
    Thanks in advance!!!
    If the ratio is like 10:1(ie., i mean very high) or more between what gets deleted and what is left behind, a better approach would be to CTAS what you want to retain and drop/truncate the old table. Rename it to original, if dropped.
    If you can't do this, there are lots of ways to improve it; at first, do as Davey said, trace. Analyze it. Diagnose. Tune it.
    Last edited by gtcol; 04-12-2009 at 02:39 AM.

Tags for this Thread

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