The default character set and collation in MySQL 8 is utf8mb4 and utf8mb4_0900_ai_ci, see https://dev.mysql.com/doc/refman/8.0/en/charset-server.html. SELECT * FROM ...
MySQL官方文档中(https://dev.mysql.com/doc/refman/5.7/en/optimization-indexes.html)有这样一段描述: The best way to improve the performance of SELECT ...