* Chuck Gadd > 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.
Yes, but that is not relevant in the case with the BENCHMARK() function, is it? No table is involved... -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]