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.Code:Any suggestions or ulternatives how we can improve the time of this job? Your help will be greatly appreciated! Thanks in advance!!!
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.![]()





Reply With Quote
