Execution Plan

SEQ OPERATION OBJECT_NAME ALIAS TYPE COST CARDINALITY PREDICATES PROJECTION ID

1 TABLE ACCESS FULL EMPLOYEES E2@SEL$4 TABLE 3 107 "E2"."SALARY"[NUMBER,22], "E2"."DEPARTMENT_ID"[NUMBER,22] 11

2 HASH GROUP BY 4 1 (#keys=1) "E2"."DEPARTMENT_ID"[NUMBER,22], MAX("E2"."SALARY")[22] 10

3 FILTER filter: MAX("E2"."SALARY")>0 "E2"."DEPARTMENT_ID"[NUMBER,22], MAX("E2"."SALARY")[22] 9

4 VIEW VW_SQ_1 VW_SQ_1@SEL$32F848CB VIEW 4 1 "MAX(E2.SALARY)"[NUMBER,22], "ITEM_1"[NUMBER,22] 8

5 INDEX RANGE SCAN EMP_DEPARTMENT_IX E1@SEL$2 INDEX 0 10 access: "ITEM_1"="E1"."DEPARTMENT_ID" "E1".ROWID[ROWID,10] 13

6 TABLE ACCESS BY INDEX ROWID EMPLOYEES E1@SEL$2 TABLE 1 1 filter: "E1"."SALARY"="MAX(E2.SALARY)" "E1"."EMPLOYEE_ID"[NUMBER,22], "E1"."FIRST_NAME"[VARCHAR2,20], "E1"."LAST_NAME"[VARCHAR2,25], "E1"."HIRE_DATE"[DATE,7] 12

7 NESTED LOOPS 5 1 (#keys=0) "E1"."EMPLOYEE_ID"[NUMBER,22], "E1"."FIRST_NAME"[VARCHAR2,20], "E1"."LAST_NAME"[VARCHAR2,25], "E1"."HIRE_DATE"[DATE,7] 7

8 INDEX UNIQUE SCAN JHIST_EMP_ID_ST_DATE_PK J@SEL$2 INDEX (UNIQUE) 0 1 access: "E1"."EMPLOYEE_ID"="J"."EMPLOYEE_ID" AND "E1"."HIRE_DATE"="J"."START_DATE" "J".ROWID[ROWID,10] 15

9 TABLE ACCESS BY INDEX ROWID JOB_HISTORY J@SEL$2 TABLE 1 1 "J"."JOB_ID"[VARCHAR2,10] 14

10 NESTED LOOPS 6 1 (#keys=0) "E1"."EMPLOYEE_ID"[NUMBER,22], "E1"."FIRST_NAME"[VARCHAR2,20], "E1"."LAST_NAME"[VARCHAR2,25], "J"."JOB_ID"[VARCHAR2,10] 6

11 INDEX FULL SCAN EMP_JOB_IX E3@SEL$3 INDEX 1 107 "E3".ROWID[ROWID,10] 16

12 NESTED LOOPS 15 107 (#keys=0) "E1"."EMPLOYEE_ID"[NUMBER,22], "E1"."FIRST_NAME"[VARCHAR2,20], "E1"."LAST_NAME"[VARCHAR2,25], "J"."JOB_ID"[VARCHAR2,10], "E3".ROWID[ROWID,10] 5

13 TABLE ACCESS BY INDEX ROWID EMPLOYEES E3@SEL$3 TABLE 9 1 filter: "E1"."EMPLOYEE_ID"="E3"."MANAGER_ID" "E3"."SALARY"[NUMBER,22] 17

14 NESTED LOOPS 15 1 (#keys=0) "E1"."FIRST_NAME"[VARCHAR2,20], "E1"."LAST_NAME"[VARCHAR2,25], "J"."JOB_ID"[VARCHAR2,10], "E3"."SALARY"[NUMBER,22] 4

15 HASH GROUP BY 17 1 (#keys=3) "E1"."FIRST_NAME"[VARCHAR2,20], "E1"."LAST_NAME"[VARCHAR2,25], "J"."JOB_ID"[VARCHAR2,10], SUM("E3"."SALARY")[22] 3

16 SORT ORDER BY 17 1 (#keys=1) SUM("E3"."SALARY")[22], "E1"."FIRST_NAME"[VARCHAR2,20], "E1"."LAST_NAME"[VARCHAR2,25], "J"."JOB_ID"[VARCHAR2,10] 2

17 VIEW V V@SEL$1 VIEW 17 1 "V"."FIRST_NAME"[VARCHAR2,20], "V"."LAST_NAME"[VARCHAR2,25], "V"."JOB_ID"[VARCHAR2,10], "V"."TOTAL_SAL"[NUMBER,22] 1

18 SELECT STATEMENT 17 1 0

SEQ	OPERATION	OBJECT_NAME	ALIAS	TYPE	COST	CARDINALITY	PREDICATES	PROJECTION	ID
1	TABLE ACCESS FULL	EMPLOYEES	E2@SEL$4	TABLE	3	107		"E2"."SALARY"[NUMBER,22], "E2"."DEPARTMENT_ID"[NUMBER,22]	11
2	HASH GROUP BY				4	1		(#keys=1) "E2"."DEPARTMENT_ID"[NUMBER,22], MAX("E2"."SALARY")[22]	10
3	FILTER						filter: MAX("E2"."SALARY")>0	"E2"."DEPARTMENT_ID"[NUMBER,22], MAX("E2"."SALARY")[22]	9
4	VIEW	VW_SQ_1	VW_SQ_1@SEL$32F848CB	VIEW	4	1		"MAX(E2.SALARY)"[NUMBER,22], "ITEM_1"[NUMBER,22]	8
5	INDEX RANGE SCAN	EMP_DEPARTMENT_IX	E1@SEL$2	INDEX	0	10	access: "ITEM_1"="E1"."DEPARTMENT_ID"	"E1".ROWID[ROWID,10]	13
6	TABLE ACCESS BY INDEX ROWID	EMPLOYEES	E1@SEL$2	TABLE	1	1	filter: "E1"."SALARY"="MAX(E2.SALARY)"	"E1"."EMPLOYEE_ID"[NUMBER,22], "E1"."FIRST_NAME"[VARCHAR2,20], "E1"."LAST_NAME"[VARCHAR2,25], "E1"."HIRE_DATE"[DATE,7]	12
7	NESTED LOOPS				5	1		(#keys=0) "E1"."EMPLOYEE_ID"[NUMBER,22], "E1"."FIRST_NAME"[VARCHAR2,20], "E1"."LAST_NAME"[VARCHAR2,25], "E1"."HIRE_DATE"[DATE,7]	7
8	INDEX UNIQUE SCAN	JHIST_EMP_ID_ST_DATE_PK	J@SEL$2	INDEX (UNIQUE)	0	1	access: "E1"."EMPLOYEE_ID"="J"."EMPLOYEE_ID" AND "E1"."HIRE_DATE"="J"."START_DATE"	"J".ROWID[ROWID,10]	15
9	TABLE ACCESS BY INDEX ROWID	JOB_HISTORY	J@SEL$2	TABLE	1	1		"J"."JOB_ID"[VARCHAR2,10]	14
10	NESTED LOOPS				6	1		(#keys=0) "E1"."EMPLOYEE_ID"[NUMBER,22], "E1"."FIRST_NAME"[VARCHAR2,20], "E1"."LAST_NAME"[VARCHAR2,25], "J"."JOB_ID"[VARCHAR2,10]	6
11	INDEX FULL SCAN	EMP_JOB_IX	E3@SEL$3	INDEX	1	107		"E3".ROWID[ROWID,10]	16
12	NESTED LOOPS				15	107		(#keys=0) "E1"."EMPLOYEE_ID"[NUMBER,22], "E1"."FIRST_NAME"[VARCHAR2,20], "E1"."LAST_NAME"[VARCHAR2,25], "J"."JOB_ID"[VARCHAR2,10], "E3".ROWID[ROWID,10]	5
13	TABLE ACCESS BY INDEX ROWID	EMPLOYEES	E3@SEL$3	TABLE	9	1	filter: "E1"."EMPLOYEE_ID"="E3"."MANAGER_ID"	"E3"."SALARY"[NUMBER,22]	17
14	NESTED LOOPS				15	1		(#keys=0) "E1"."FIRST_NAME"[VARCHAR2,20], "E1"."LAST_NAME"[VARCHAR2,25], "J"."JOB_ID"[VARCHAR2,10], "E3"."SALARY"[NUMBER,22]	4
15	HASH GROUP BY				17	1		(#keys=3) "E1"."FIRST_NAME"[VARCHAR2,20], "E1"."LAST_NAME"[VARCHAR2,25], "J"."JOB_ID"[VARCHAR2,10], SUM("E3"."SALARY")[22]	3
16	SORT ORDER BY				17	1		(#keys=1) SUM("E3"."SALARY")[22], "E1"."FIRST_NAME"[VARCHAR2,20], "E1"."LAST_NAME"[VARCHAR2,25], "J"."JOB_ID"[VARCHAR2,10]	2
17	VIEW	V	V@SEL$1	VIEW	17	1		"V"."FIRST_NAME"[VARCHAR2,20], "V"."LAST_NAME"[VARCHAR2,25], "V"."JOB_ID"[VARCHAR2,10], "V"."TOTAL_SAL"[NUMBER,22]	1
18	SELECT STATEMENT				17	1			0