SQL> DROP TABLE EMP1;

Table dropped.

SQL> CREATE TABLE EMP1 AS SELECT empno FROM EMP WHERE ROWNUM = 1;

Table created.

SQL> CREATE INDEX EMP_INDX ON EMP1(EMPNO);

Index created.

SQL> explain plan for select * from emp1 where empno = 7369;

Explained.

SQL>
SQL> SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------
Plan hash value: 3038152044

-----------------------------------------------------------------------------
| Id  | Operation        | Name     | Rows  | Bytes | Cost (%CPU)| Time     |
-----------------------------------------------------------------------------
|   0 | SELECT STATEMENT |          |     1 |     4 |     1   (0)| 00:00:01 |
|*  1 |  INDEX RANGE SCAN| EMP_INDX |     1 |     4 |     1   (0)| 00:00:01 |
-----------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - access("EMPNO"=7369)

13 rows selected.