查看“︁MySQL explain”︁的源代码

<pre>
mysql> explain SELECT COUNT(*) FROM vehicle_prod WHERE fin LIKE '%00000';
+----+-------------+--------------+------------+-------+---------------+----------------------+---------+------+---------+----------+--------------------------+
| id | select_type | table        | partitions | type  | possible_keys | key                  | key_len | ref  | rows    | filtered | Extra                    |
+----+-------------+--------------+------------+-------+---------------+----------------------+---------+------+---------+----------+--------------------------+
|  1 | SIMPLE      | vehicle_prod | NULL       | index | NULL          | idx_vehicle_prod_fin | 203     | NULL | 3182812 |    11.11 | Using where; Using index |
+----+-------------+--------------+------------+-------+---------------+----------------------+---------+------+---------+----------+--------------------------+
1 row in set, 1 warning (0.00 sec)
</pre>


[[Category:Datebase]]