* 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]

Reply via email to