explain plan for select * from emp where deptno=10 order by ename;
select * from table(dbms_xplan.display);
1.SELECT STATEMENT
2. SORT ORDER B Y
3. TABLE ACCESS FULLE
2 - filter("DEPTNO"=10)
explain plan for select * from emp where deptno=10 order by ename;
select * from table(dbms_xplan.display);
1.SELECT STATEMENT
2. SORT ORDER B Y
3. TABLE ACCESS FULLE
2 - filter("DEPTNO"=10)