MySQL Performance – eliminating ORDER BY function

(Peter Zaitsev) One of the first rules you would learn about MySQL Performance Optimization is to avoid using functions when comparing constants or order by. Ie use indexed_col=N is good. function(indexed_col)=N is bad because MySQL Typically will be unable to use index on the column even if functio

Read More - Register for Free Membership