I have a program which updates tcodes from tstc table into a Ztable.
It has to be run on daily basis as a background job.
My problem is that if I create a new Tcode it will update only that tcode into custom table but before that it compares all the entries of tstc and ztable which is impacting the overall performance.
I means if I am having 100000 entries in both the tables and if I create a new tcode then to update only that record, I have to create a loop which will iterate for 100000 times.
Can anyone please suggest me any method which will improve the performance of report?