mysql(2)
-
MySQL 실행계획(Explain) 엑스트라(Extra) 속도 순서
1. system 2. const 3. eq_ref 4. ref 5. fulltext 6. ref_or_null, 7. unique_subquery 8. index subquery 9. range 10. index_merge 11. index 12. all
2021.01.12 -
MySQL 처리 순서
SELECT ~ FROM ~ WHERE ~ GROUP BY ~ HAVING ~ ORDER BY ~ 5 1 2 3 4 6 1. FROM 2. WHERE 3. GROUP 4. HAVING 5. SELECT 6. ORDER BY
2021.01.12