What is the impact of database recovery model on Data update job execution time.
If we switch between Simple/Full what is the performance impact
It will not effect the execution time of the DUJ. The main impact will be that the transaction log will become a lot bigger. If you have FULL the database will empty it when you do a backup. When you run with simple it will be emptied whenever the transaction is over.
Retrieving data ...