… because MySQL Typically will be unable to use index on the column even if function is very simple such as arithmetic operation. Same… so sort phase can be skipped all together. Note in this case MySQL Optimizer is rather smart and is able to do… functions are different MySQL is not able to do this optimization even in cases when this would be possible: mysql> explain select * from…