对multmillion行表(MySQL)的查询的性能

From anybody with real experience, how do LIKE queries perform in MySQL on multi-million row tables, in terms of speed and efficiency, if the field has a plain INDEX?From anybody with real experience, how do LIKE