topic Performance for nested loop of different structured tables. in Application Development and Automation Discussions

Performance for nested loop of different structured tables.

Former Member — Wed, 04 Sep 2013 07:43:24 GMT

Hi everyone,

I have been searching over the internet for my problem but haven't found the right solution.

My query is how do you improve performance in a Nested loop of tables that don't have any shared field.

I have found a lot of stuff over the internet for improving performance with Parallel Cursor but they are all using the same field in both the tables.

In my case the two tables do not have any common field.

Please let me know if anyone has an idea.

Regards

Piyush.

Re: Performance for nested loop of different structured tables.

former_member184455 — Wed, 04 Sep 2013 15:03:06 GMT

Hi Piyush,

If your tables have no relation (no common fields that restrict the range to be searched for the inner table of the nested loop), the number of loop-steps has to be m times n, where m and n are the number of entries in the two tables. This cannot be speed up.

Another question is: what type of business process is it to mix to tables with no common fields?

And how many entries do the tables have?

Best Regards, Randolf

Re: Performance for nested loop of different structured tables.

Former Member — Thu, 05 Sep 2013 04:55:44 GMT

This message was moderated.