hash join1 MySQL Hash Join Optimization 출처 : https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html MySQL :: MySQL 8.0 Reference Manual :: 8.2.1.4 Hash Join Optimization 8.2.1.4 Hash Join Optimization Beginning with MySQL 8.0.18, MySQL employs a hash join for any query for which each join has an equi-join condition and uses no indexes, such as this one: SELECT * FROM t1 JOIN t2 ON t1.c1=t2.c1; A hash join is usually faster dev.mysql... 2019. 10. 2. 이전 1 다음