MySQL explain实际操作流程说明
实际说明复制MySQL> explain SELECT * FROM `whisper` WHERE to_id = 6696 AND del = 0 AND whisper=0 ORDER BY `send_time` DESC LIMIT 4; +----+-------------+---------+------+---------------+-------+---------+-------+------+-----------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------+------+---------------+-------+---------+-------+------+-----------------------------+ | 1 | SIMPLE | whisper | ref | to_id | to_id | 4 | const | 1 | Using where; Using filesort | +----+-------------+---------+------+---------------+-------+---------+-------+------+-----------------------------+ 1 row in set (0.00 sec) 1.2.3.4.5.6.7.
本文地址：http://www.bhae.cn/html/05f9099904.html
版权声明
本文仅代表作者观点，不代表本站立场。
本文系作者授权发表，未经许可，不得转载。