MYSQL中EXPLAIN的说明 | |
| |
mysql> explain select count(id) from t_prehandle_zhigao_05 as zhigao where start_time > '2008-05-30'; +----+-------------+--------+-------+---------------+------------+---------+------+---------+--------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+--------+-------+---------------+------------+---------+------+---------+--------------------------+ | 1 | SIMPLE | zhigao | range | start_time | start_time | 8 | NULL | 1061762 | Using where; Using index | +----+-------------+--------+-------+---------------+------------+---------+------+---------+--------------------------+ 1 row in set (0.00 sec) mysql> EXPLAIN列的解释:
|
MYSQL中EXPLAIN的说明
最新推荐文章于 2024-01-24 17:00:12 发布