Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions
Thanks for the question, OnkarNath.
Asked: November 05, 2012 - 11:57 pm UTC
Last updated: November 06, 2012 - 8:59 am UTC
Version: 11.1.0
Viewed 1000+ times
explain plan for select * from emp where ename like 'S%';
select * from table (dbms_xplan.display()); PLAN_TABLE_OUTPUT -------------------------------------------------------------------------- Plan hash value: 3956160932 -------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | -------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 2 | 74 | 3 (0)| 00:00:01 | |* 1 | TABLE ACCESS FULL| EMP | 2 | 74 | 3 (0)| 00:00:01 | -------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("ENAME" LIKE 'S%') 13 rows selected.
More on PL/SQL routine DBMS_XPLAN here