Roger Baklund wrote:
Either way, I was surprised to see the "like" to be in the top
performers and "left()" to be last.
I suppose the LIKE operator is optimized for the case when it begins with a
constant:
mysql> select BENCHMARK(10000000, 'dfsfsdfs' like '%F%' );
1 row in set (3.43 sec)
MySql will use indexes to optimize LIKE queries if the expression
does not start with a wildcard character.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]