On Tue, 5 Aug 2003, gerald_clark wrote: > You are ORing on two different fields. The index cannot be used to > check the value of z for an OR.
"ORing on two different fields" is what I have been asking about :). Using a composite index was suggested, which strangely seems to work only when there are no other columns in the table. > Why are you cross posting? Initially because I didn't know which list was appropriate, and later in response. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]