SQL query optimization

SELECT query

{EXPLAIN | DESCRIBE | DESC} 

We usually use this command to check to see if how many rows the query goes through. Especially for the INDEX column checking.

Search

LIKE '%key%' consumes more resource than LIKE 'key%'

Denormalisation

This database design helps to speed up the data reading. Because the SQL query no need to join data between tables.