Here's what happens at execution time for the first leg of the nested loop join.

以下是在执行嵌套循环联接的第一步时将发生的操作。

youdao

Because of how nested loop joins work, the second leg (there are four nodes) is executed per outer table record.

因为嵌套循环联接的工作方式，所以每隔一个外部表记录执行第二步(共4个节点)。

youdao

Because of how nested loop joins work, the second leg (there are four nodes) is executed per outer table record.

因为嵌套循环联接的工作方式，所以每隔一个外部表记录执行第二步(共4个节点)。

youdao