超级会员免费看
本文介绍了MySQL中的Block Nested-Loop (BNL) 和 Batched Key Access (BKA) Join算法，这两种算法用于提高内外连接和半连接操作的性能。BKA算法利用索引访问和join缓冲区，而BNL算法扩展到支持外连接和半连接。这些优化包括更有效的表扫描和减少复制时间，从而节省内存和提高处理速度。
MySQL :: MySQL 5.7 Reference Manual :: 8.2.1.11 Block Nested-Loop and Batched Key Access Joins
8.2.1.11 Block Nested-Loop and Batched Key Access Joins
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer joins. Benefits of BKA includ
订阅专栏 解锁全文
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
