Entry

Why mysql doesn't use index in queries/DML that the where clause use 'or ' operator

Feb 16th, 2004 16:37
Tom Keyser, Hamba Allah,

Use IN instead of OR and MYSQL will use indexes

INCORRECT: this = '1' or this = '2'
CORRECT: this IN('1','2')