语法
EXPLAIN [EXTENDED | DEPENDENCY | AUTHORIZATION] query
案例:
(1)查看下面这条语句的执行计划
explain select * from emp;
explain select deptno, avg(sal) avg_sal from emp group by deptno;
(2)查看详细执行计划
explain extended select * from emp;
explain extended select deptno, avg(sal) avg_sal from emp group by deptno;