MySQL condition using an OR query does not trigger an index?

The argument is that an or is present in the Where condition and the index is not used


My test results are as follows:

Mysql> explain select * from emp where ename= "Dsleos" or ename= "Saesad" \g*************************** 1. Row ***************************           id:1  select_type:simple        table:emp         type:rangepossible_keys:e_i          key:e_i      key_len:62          ref:null         rows:2        extra:using where1 row in Set (0.00 sec)

The index is triggered, is the use or will not trigger the index AH?

Reply to discussion (solution)

Of course the index is gone.
Of course, if you are just testing, because the data in the database is not large enough, the MySQL engine may intelligently discard the index and query directly.

The fields before or after the or are indexed, so they go indexed (it looks like the results of the MyISAM engine and the InnoDB engine are different. ）

