Database Reference
In-Depth Information
AND "EMP"."DEPARTMENT_ID"="D"."DEPARTMENT_ID"
AND "D"."LOCATION_ID"="L"."LOCATION_ID" AND "EMP"."JOB_ID"="J"."JOB_ID"
Query block (04AEA6B4) unchanged
CBQT: Validity checks failed for 2ck90xfmsza4u.
***************
Subquery Unnest
***************
SU: Considering subquery unnesting in query block SEL$1 (#0)
*************************
Set-Join Conversion (SJC)
*************************
SJC: Considering set-join conversion in SEL$1 (#0).
**************************
Predicate Move-Around (PM)
**************************
PM: Considering predicate move-around in SEL$1 (#0).
PM: Checking validity of predicate move-around in SEL$1 (#0).
PM: PM bypassed: Outer query contains no views.
FPD: Considering simple filter push in SEL$1 (#0)
FPD: Current where clause predicates in SEL$1 (#0) :
"L"."CITY"=:B1 AND "EMP"."MANAGER_ID"="MGR"."EMPLOYEE_ID"
AND "EMP"."DEPARTMENT_ID"="D"."DEPARTMENT_ID"
AND "D"."LOCATION_ID"="L"."LOCATION_ID"
AND "EMP"."JOB_ID"="J"."JOB_ID"
kkogcp: try to generate transitive predicate from check constraints for SEL$1 (#0)
constraint: "MGR"."SALARY">0
constraint: "EMP"."SALARY">0
predicates with check contraints: "L"."CITY"=:B1
AND "EMP"."MANAGER_ID"="MGR"."EMPLOYEE_ID"
AND "EMP"."DEPARTMENT_ID"="D"."DEPARTMENT_ID"
AND "D"."LOCATION_ID"="L"."LOCATION_ID"
AND "EMP"."JOB_ID"="J"."JOB_ID" AND "MGR"."SALARY">0 AND "EMP"."SALARY">0
after transitive predicate generation:
"L"."CITY"=:B1 AND "EMP"."MANAGER_ID"="MGR"."EMPLOYEE_ID"
AND "EMP"."DEPARTMENT_ID"="D"."DEPARTMENT_ID"
AND "D"."LOCATION_ID"="L"."LOCATION_ID" AND "EMP"."JOB_ID"="J"."JOB_ID"
AND "MGR"."SALARY">0 AND "EMP"."SALARY">0
finally: "L"."CITY"=:B1 AND "EMP"."MANAGER_ID"="MGR"."EMPLOYEE_ID"
AND "EMP"."DEPARTMENT_ID"="D"."DEPARTMENT_ID"
AND "D"."LOCATION_ID"="L"."LOCATION_ID" AND "EMP"."JOB_ID"="J"."JOB_ID"
apadrv-start: call(in-use=744, alloc=0), compile(in-use=47988, alloc=0)
kkoqbc-start
: call(in-use=756, alloc=0), compile(in-use=49312, alloc=0)
The optimizer retrieves check constraints from the data dictionary to generate additional
predicates (
AND "MGR"."SALARY">0 AND "EMP"."SALARY">0
).
