if(pid = peek('pid',-1),'rescheduled','new') as appointment_type
Drop table Table1;
It should not take too much longer to load. It would, if you would not do the Drop table statement as it would start to create synthetic key. But as you are dropping the Table1 and keeping only the NewTable, this should be fairly quick load.