Performance for nested loop of different structured tables.

[Former Member]

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.

[former_member184455]

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

[Former Member]

This message was moderated.