Oracle Explain Plan

create table t1(c1 int, c2 char(10));

insert into t1 

select level,'dummy' from dual  connect by level<=10000;

create index t1_n1 on t1(c1);

explain plan for

select * from t1 where c1=1 and c2='dummy';

select * from table(dbms_xplan.display);

------------------------------------------------------

SELECT e.ename, e.sal, d.loc, e.deptno

  FROM emp e, dept d

 WHERE e.deptno = d.deptno;

 

 grant plustrace to scott;

 

  ALTER SESSION SET sql_trace = TRUE;