A function on any column does not negate the use of the index. That
only happens if you use a function in a filter part (join, where, etc.).
You may want to run optimize table on the 2 tables involved. That
will update the table stats that mysql uses to optimize the queries.
MySQL may
On Wednesday 07 November 2007, Charles Jardine wrote:
I am planning to set up a system in which mysql servers access
their data via NFS. All the computers involved run Solaris 10.
NFS version 4 will be used.
I plan to ensure that no NFS share is ever mounted by more than
one client computer,
Hi Moritz,
Thus, my questions:
- what's wrong with that query? I know they are big tables, but
according to EXPLAIN, this should be fast enough, because mysql's seeing
the indexes just fine.
As others have said, likely nothing wrong with the query per se. It
just sounds like you're
