EXPLAIN SELECT * FROM `PARTITIONS`
ORDER BY `PARTITIONS`.`PARTITION_DESCRIPTION` ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | PARTITIONS | ALL | NULL | NULL | NULL | NULL | NULL | Open_full_table; Scanned all databases; Using file... |