测试oracle 11g固定执行计划-Baseline(三)
7 (15)| 00:00:01 |
|* 1 | HASH JOIN SEMI | | 1 | 19 | 7 (15)| 00:00:01 |
|* 2 | TABLE ACCESS FULL| DEPARTMENTS | 1 | 16 | 3 (0)| 00:00:01 |
| 3 | TABLE ACCESS FULL| EMPLOYEES | 107 | 321 | 3 (0)| 00:00:01 |
----------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
www.2cto.com
1 - access("DEPARTMENT_ID"="DEPARTMENT_ID")
2 - filter("DEPARTMENT_NAME"=:NAME)
Note
—–
- SQL plan baseline SYS_SQL_c9bc6fc0e997f27c used for this statement
作者 Coast_lichao