It's possible mysql optimizes queries incorrectly. I've had to "correct it" on a few occasions. If you look at the results of the
explain for Q1, you'll notice that in both queries the key_len is 1. Meaning Mysql thinks it only needs to look at the first
"character" of the index. Based on that "o
Hi Kelvin, all!
Kelvin Wu wrote:
I am looking for help and suggestion.
Mysql Ver 12.18 Distrib 4.0.12, for pc-linux (i686)
The table structure:
[[...]]
I created multiple parts of Index for this table:
[[...]]
And here are the questions:
Q1: the query is supposed to use index bynone but ...
BTW, I have force to use index key by using USE INDEX (bysource) for
example, in the query, but it didn't look good to me...
--
Sent from my BlackBerry. Ignore the typos unless they're funny.
