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 se
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 | k
