MySQL-5.7-8.2.1.6 Nested-Loop Join Algorithms(嵌套循环连接算法)
MySQL executes joins between tables using a nested-loop algorithm or variations on it.MySQL使用嵌套循环算法或其变体来执行表之间的连接。Nested-Loop Join Algorithm嵌套循环连接算法A simple nested-loop join (NLJ) algorithm reads rows from the first table in a loop one at a time, pa
