SQL> select * from table(dbms_xplan.display); PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------- --------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost | --------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 24 | 2 | | 1 | TABLE ACCESS BY INDEX ROWID| EMPLOYEE | 1 | 24 | 2 | |* 2 | INDEX RANGE SCAN | EMP_IDX1 | 1 | | 1 | --------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------- 2 - access("EMPLOYEE"."EMP_ID"=64523) Note: cpu costing is off 15 rows selected.