Problem while updating tcodes from tstc to Ztable

Hi Guys,

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?

Thanks,

Neha