DB/SQL
Data mining
Query Performance
Ref
join
mysql workbench
Scan
full scan
range scan
word
processure
optimize
query cost
nested
execution plan (query plan)
index - primary key, foreign key
Prepared Statement
SQL
Ref
SQL Coding Best Practices for Writing Clean Code
MySQL data count in 10 minute intervals
ref
MySQL κ³μ°νκ±°λ λ¬Έμμ΄μ κ²°ν©ν΄μ νμνκΈ°, MySQL ν¨μ μ¬μ©νκΈ°
OracleSQL - μ€μ²© κ·Έλ£Ήν¨μ / λΆμν¨μ
sql group by 2κ° μ΄μ : λλ κΈ°μ€μ select μ μλ λκ°μ΄ μ μ΄μ£Όλ©΄ λλ€.
Last updated