I have table having around 5 million records which is being trucated in night and reloaded with fresh data. Since table is truncated, few days back we started having issues where loading was getting failed and since table was truncated, we lost old data also, we are looking to change the logic but i have confusion over the change as it may cause performance issue. Need idea/suggetion about the problem.