• #til

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

til 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 post?

If you found this helpful, consider sharing it or leaving a kudo!

0 kudos