TT_11098 INFO: Joiner [JNR_A] is set up with join algorithm: Sorted-Merge.
TT_11098 INFO: Joiner [JNR_B] is set up with join algorithm: Nested-Loop.
These messages refer to the algorithm used to perform the joining of two sources.
Sorted Merge is the more efficient algorithm. Nested Loop requires to read and insert into cache every row of the master source before starting to join. The consequence is a higher memory consumption and higher number of input/output (I/O) operations when using the Nested Loop algorithm.
What can we do to improve this information (2000 or fewer characters)