Hi,
I have a table with about 1.5M rows.
9 of the colums are varchar(9)'s.
when I just select on one of them it goes fine, like:
explain select * from t1 where f2 = 'COM051000';
+---+--+---++-+---+--++
| table | type | possible_keys |
MySQL uses only one index for a select, so it can't use an index
when there is an OR in the where clause.
Ask Bjoern Hansen wrote:
Hi,
I have a table with about 1.5M rows.
9 of the colums are varchar(9)'s.
when I just select on one of them it goes fine, like:
explain select *