MySQL View index usage

Show status like ' handler_read% ';

Handler_read_key represents the number of times a row is indexed, and a low value indicates that the index is not frequently used, and that increasing the index is not a good performance improvement.

Handler_read_rnd_text represents the number of requests to read the next line in the data file, and if a large number of table scans are performed, the Handler_read_rnd_next will be high, indicating that the table index is incorrect or the query being written does not utilize the index.

MySQL View index usage