Database Reference
In-Depth Information
SQL> SELECT *
FROM table (DBMS_XPLAN.DISPLAY_CURSOR(null, null, 'ALL ALLSTATS LAST'));
PLAN_TABLE_OUTPUT
-------------------------------------
SQL_ID b70r97ta66g1j, child number 0
-------------------------------------
SELECT e.last_name, e.first_name, e.salary, d.department_name
FROM hr.employees e, hr.departments d
WHERE e.department_id=d.department_id
AND e.salary > :sal
AND e.hire_date > to_date(:hired, 'dd.mm.yy')
AND d.department_name=:dname
Plan hash value: 2912831499
-------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows |
-------------------------------------------------------------------------
|* 1 | TABLE ACCESS BY INDEX ROWID| EMPLOYEES | 1 | 3 |
| 2 | NESTED LOOPS | | 1 | 3 |
|* 3 | TABLE ACCESS FULL | DEPARTMENTS | 1 | 1 |
|* 4 | INDEX RANGE SCAN | EMP_DEPARTMENT_IX | 1 | 10 |
-------------------------------------------------------------------------
-------------------------------------------------------------------------
|E-Bytes| Cost (%CPU)| E-Time | A-Rows | A-Time | Buffers | Reads |
-------------------------------------------------------------------------
| 90 | 1 (0)| 00:00:01 | 4 |00:00:00.03 | 13 | 15 |
| 138 | 4 (0)| 00:00:01 | 47 |00:00:00.02 | 10 | 7 |
| 16 | 3 (0)| 00:00:01 | 1 |00:00:00.01 | 8 | 6 |
| | 0 (0)| | 45 |00:00:00.01 | 2 | 1 |
-------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$1 / E@SEL$1
3 - SEL$1 / D@SEL$1
4 - SEL$1 / E@SEL$1
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter(("E"."SALARY">:SAL AND "E"."HIRE_DATE">TO_DATE(:HIRED,'dd.mm.yy')))
3 - filter("D"."DEPARTMENT_NAME"=:DNAME)
4 - access("E"."DEPARTMENT_ID"="D"."DEPARTMENT_ID")
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - "E"."FIRST_NAME"[VARCHAR2,20], "E"."LAST_NAME"[VARCHAR2,25], "E"."SALARY"[NUMBER
,22]
2 - "D"."DEPARTMENT_NAME"[VARCHAR2,30], "E".ROWID[ROWID,10]
3 - "D"."DEPARTMENT_ID"[NUMBER,22], "D"."DEPARTMENT_NAME"[VARCHAR2,30]
4 - "E".ROWID[ROWID,10]
