Simple explanation of xplan plan

Simple explanation of xplan plan

SQL> explain plan for select * from emp where deptno=20;

SQL> create index idx1 on emp(deptno);
Index created.