SQL> conn cowork_czsh/cowork_czsh
Connected.
SQL> set linesize 200
SQL> set pagesize 200
SQL> set autot trace
SQL> select workitemhi0_.PERFORMER as col_0_0_
from WORKITEM_HISTORY workitemhi0_
where (to_char(workitemhi0_.CASEID) in
(select pubformcas1_.CASE_ID
from WF_PUB_FORM_CASE pubformcas1_
where (pubformcas1_.FORM_ID = '1292892470448ejk57w15i5xw7ias6f13rpd18iqc19e7d1jy'))); 2 3 4 5 6
27 rows selected.
Execution Plan
----------------------------------------------------------
Plan hash value: 2272759491
------------------------------------------------------------
| Id | Operation| Name |
------------------------------------------------------------
| 0 | SELECT STATEMENT| |
| 1 | MERGE JOIN| |
| 2 | SORT JOIN| |
| 3 | TABLE ACCESS FULL| W