UPDATE: * s/Using join cache/Using join buffer/, changed to show the final variants of EXPLAIN output as described here * s/join_buff_size/join_buffer_size/ Starting from 5.1.18, EXPLAIN output may show “Using join cache“, like in this example: mysql> explain select * from t1, t2 where t1.col < 10 and t2.col < 'bar'; +----+-------------+-------+-------+-...-+--------------------------------+ | id
![Use of join buffer is now visible in EXPLAIN](https://cdn-ak-scissors.b.st-hatena.com/image/square/c2ea435ef3b723a8f449f8109e44c6c4485560fa/height=288;version=1;width=512/https%3A%2F%2Fsergeipetrunia.files.wordpress.com%2F2020%2F11%2F8be76-nl-join-buffering.png)