概述
在TiDB中可以使用explain和explain analyze来查看sql的执行计划。两者区别:explain不会区执行sql,而explain analyze会去执行sql,另外explain analyze显示的内容比explain更全面。
案例
1. explain
explain select
faultdata0_.project_id as project_1_3_,
faultdata0_.timestamp as timestam2_3_,
faultdata0_.ytag as ytag3_3_,
faultdata0_.content as content4_3_