til

#TIL : Index is useless when use function on indexed field

I learned on 2015-12-01 about index, mysql, sql

#index #mysql #sql

Reality, if using function on indexed field, you will broke indexing by accident.
Eg:

WHERE MONTH(`date`) = 11 AND YEAR(`date`) = 2015

Solution is transform the query to comparison query, like this :

WHERE `date` >= '2015-11-01' AND `date` < '2015-12-01'

Enjoyed this?

Leave a kudo — it means a lot.

0