implement join on internal table

Former Member — Tue, 15 Jan 2008 18:25:26 GMT

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.

Re: implement join on internal table

Former Member — Tue, 15 Jan 2008 18:28:50 GMT

Please see:

[The Performance of Nested Loops|/people/rob.burbank/blog/2006/02/07/performance-of-nested-loops]

Rob