, but even though there is an ORDER
option, there is no LIMIT option here (feature request? :-) )
Maybe using a variable to keep track of internal count...
--
- Peter Brodersen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
-issue, since the file is pretty
small and the cpu is utilized (instead of a high iowait-state).
What is the reason for an index drop to take that amount of time?
(I'm not dropping indexes on a daily basis - my question is mainly out
of curiousity :) )
--
- Peter Brodersen
--
MySQL General
Hi,
I was using a 4.0.13-server and wondering about why LEFT() doesn't take
advantage of an index, the way .. LIKE X% .. does. I was wondering if
there would be any effort in implementing this optimisation, or if
people should just be encouraged to use LIKE (as bug #747 mentions)?
--
- Peter