EXPLAIN SELECT * FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME` = 'information_schema' ORDER BY `DEFAULT_COLLATION_NAME` ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | SCHEMATA | ALL | NULL | NULL | NULL | NULL | NULL | Using where; Using filesort |