Hello All,

Sorry this took a bit but I started over with all of the indexing. It led to much better results I added PK's to each of the stage tables. I also am testing out different fill factor changes. I'm in a EDW so right now I'm testing with 100. I have a much improved execution plan. My total execution time has remained the same however the rows processed has increased overall by 20 million now (65+ million) so I think the new changes are having a impact. I'm sure there is more that can be done. Attached is the latest execution plan.

Also I have added Explicit Trans with TRY CATCH, however another team member is asking if that will cause a performance hit. Any truth to that ? I'm doing it for data integrity and error handling. Just checking to see if I'm wrong on this part or if I should just leave this process implicit.

Thanks as always. Still learning !