MariaDB [test]> create table t1 (a int, b int) engine=MyISAM;
|
Query OK, 0 rows affected (0.24 sec)
|
|
MariaDB [test]> explain select * from t1;
|
+------+-------------+-------+--------+---------------+------+---------+------+------+---------------------+
|
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|
+------+-------------+-------+--------+---------------+------+---------+------+------+---------------------+
|
| 1 | SIMPLE | t1 | system | NULL | NULL | NULL | NULL | 0 | const row not found |
|
+------+-------------+-------+--------+---------------+------+---------+------+------+---------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> analyze select * from t1;
|
+------+-------------+-------+------+---------------+------+---------+------+------+--------+----------+------------+--------------------------------+
|
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | r_rows | filtered | r_filtered | Extra |
|
+------+-------------+-------+------+---------------+------+---------+------+------+--------+----------+------------+--------------------------------+
|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | no matching row in const table |
|
+------+-------------+-------+------+---------------+------+---------+------+------+--------+----------+------------+--------------------------------+
|
1 row in set (0.01 sec)
|