New answers tagged functions
First, the possible_keys shows null because there is no index on any of the two columns used in the WHERE clause. So, there is no useful index to even be considered for this query. But even when you add an index on (expirydatetime), the situation is still not good. Because when you place a column inside a function in a condition, like the ...
Top 50 recent answers are included