mysql> explain SELECT COUNT(*) FROM vehicle_prod WHERE fin LIKE '%00000'; +----+-------------+--------------+------------+-------+---------------+----------------------+---------+------+---------+----------+--------------------------+ | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra | +----+-------------+--------------+------------+-------+---------------+----------------------+---------+------+---------+----------+--------------------------+ | 1 | SIMPLE | vehicle_prod | NULL | index | NULL | idx_vehicle_prod_fin | 203 | NULL | 3182812 | 11.11 | Using where; Using index | +----+-------------+--------------+------------+-------+---------------+----------------------+---------+------+---------+----------+--------------------------+ 1 row in set, 1 warning (0.00 sec)