oracle 对索引to_char,to_char函数引发的不走索引

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