I have a table called
users with a column
firstname and with
I want to know what happens under the hood when I execute an query like:
SELECT * FROM `users` `a` WHERE `a`.`firstname` = 'sander' COLLATE utf8_general_ci
firstname isn't an index, what happens with the performance when the command executed?
And what if the default collation was
utf8_general_ci and the query is executed without
I want to know the impact it has on a big table.