re: Indices do not seem to work for OR queries

2003-03-03 Thread Egor Egorov
On Saturday 01 March 2003 01:26, Henning Schulzrinne wrote: > Both email columns have the same format (varchar) and are indexed > individually: > > describe SELECT person FROM person WHERE email1='foo' OR email2='foo'; > ++--+---+--+-+--+---+--

Indices do not seem to work for OR queries

2003-02-28 Thread Henning Schulzrinne
Both email columns have the same format (varchar) and are indexed individually: describe SELECT person FROM person WHERE email1='foo' OR email2='foo'; ++--+---+--+-+--+---+-+ | table | type | possible_keys | key | key_len | ref | rows |