mysql 8.02 MySQL EXPLAIN ANALYZE 출처 : https://dev.mysql.com/doc/refman/8.0/en/explain.html MySQL :: MySQL 8.0 Reference Manual :: 13.8.2 EXPLAIN Syntax {EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | FOR CONNECTION connection_id} {EXPLAIN | DESCRIBE | DESC} ANALYZE select_statement explain_type: { FORMAT = format_name } format_name: { T dev.mysql.com MySQL 8... 2019. 10. 2. 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 다음