Database Reference
In-Depth Information
--------------------------------------------------------------
| Id | Cost (%CPU)| E-Time | A-Rows | A-Time | Buffers |
--------------------------------------------------------------
| 0 | 2 (100)| | 1 |00:00:00.01 | 4 |
| 1 | 2 (0)| 00:00:01 | 1 |00:00:00.01 | 4 |
| 2 | 1 (0)| 00:00:01 | 1 |00:00:00.01 | 2 |
|* 3 | 0 (0)| | 1 |00:00:00.01 | 1 |
|* 4 | 1 (0)| 00:00:01 | 1 |00:00:00.01 | 2 |
|* 5 | 0 (0)| | 1 |00:00:00.01 | 1 |
--------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$1
2 - SEL$1 / D@SEL$1
3 - SEL$1 / D@SEL$1
4 - SEL$1 / E@SEL$1
5 - SEL$1 / E@SEL$1
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.1.0.7')
DB_VERSION('11.1.0.7')
FIRST_ROWS
OUTLINE_LEAF(@"SEL$1")
INDEX_RS_ASC(@"SEL$1" "D"@"SEL$1" ("DEPARTMENTS"."DEPARTMENT_ID"))
INDEX_RS_ASC(@"SEL$1" "E"@"SEL$1" ("EMPLOYEES"."EMPLOYEE_ID"))
LEADING(@"SEL$1" "D"@"SEL$1" "E"@"SEL$1")
USE_NL(@"SEL$1" "E"@"SEL$1")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - (NUMBER): 50
2 - (NUMBER): 120
3 - (VARCHAR2(30), CSID=178): 'Matthew'
Predicate Information (identified by operation id):
---------------------------------------------------
3 - access("D"."DEPARTMENT_ID"=:DEPT_ID)
4 - filter(("FIRST_NAME"=:FN AND "E"."DEPARTMENT_ID"=:DEPT_ID))
5 - access("E"."EMPLOYEE_ID"=:EMP_ID)
Column Projection Information (identified by operation id):
Search WWH ::




Custom Search