不指定访问路径方式生成的执行计划为啥有乱码?
EXPLAIN SELECT * FROM `teacher` WHERE `email` like 'zhang%';
输出结果如下:
obclient [testdb]> EXPLAIN SELECT * FROM `teacher` WHERE `email` like 'zhang%';
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Query Plan |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ===================================================================== |
| |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)| |
| --------------------------------------------------------------------- |
| |0 |TABLE RANGE SCAN|teacher(ux_teacher_email)|1 |7 | |
| ===================================================================== |
| Outputs & filters: |
| ------------------------------------- |
| 0 - output([teacher.id], [teacher.name], [teacher.sex], [teacher.mobile_phone], [teacher.email], [teacher.create_time], [teacher.update_time]), filter(nil), rowset=16 |
| access([teacher.id], [teacher.email], [teacher.name], [teacher.sex], [teacher.mobile_phone], [teacher.create_time], [teacher.update_time]), partitions(p0) |
| is_index_back=true, is_global_index=false, |
| range_key([teacher.email], [teacher.shadow_pk_0]), range(zhang,MIN ; zhang� |
| ��� |
| ��, |
| MAX), |
| range_cond([(T_OP_LIKE, teacher.email, 'zhang%', '\\')]) |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
15 rows in set (0.003 sec)