hi all,
i have a report, which contains data from 2 database tables having around 5-6 million data each.
now, the from both the tables, respective internal tables are filled using select queries which have data around 1000 and 50,000 respectively.
now according to the requirements, i have to compare data by joining the two internal tables depending on a certain field.
so, for doing that, i have to use a nested loop on both the tables with condition on single field.
due to large data, and involved procedure in the loop, it is taking toooo long (almost around 3-4 hours) to execute the entire program.
i belive there in no join on internal tables (if there is, plz let me know syntax)...
please suggest a way around!
if you have not understood the problem, let me know, i will clarify!
thanx in advance.