I have a recurring job that extracts some data from a table and inserts it into another table.
What I am currently doing is deleting all data from the target table and then do the extract from the originating table. (Because I always need the newest data)
I am wondering if that is a good practice in terms of performance. Or should I use Drop Table - Create Table each time?
Any comment or recommendation will be appreciated.
Thanks in advance