"Jim Page - EMF Systems Ltd" <[EMAIL PROTECTED]> wrote on 07/04/2004
17:14:57:
> PS I am answering loads of questions in the hope that the power of my
Karma
> will force someone to answer mine ... (join problem:indexed columns being
> ignored)
My first reaction would be to turn your index round. Something with
settings of "y" and "n" is going to make a rotten index, especially as the
first part. It is possible that MySQL will look at that part of it, decide
that this is a lousy index, and ditch it. If you put the diffuse part of
the index first, then the boolean, it might sort better. I don't think you
have to change your query - I think MySQL is savvy enough to commute over
the AND.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
