to_char函数引发的不走索引

最新推荐文章于 2024-06-13 15:20:51 发布

scan724

最新推荐文章于 2024-06-13 15:20:51 发布

阅读量4.9k

点赞数

分类专栏： sql 查询优化

本文链接：https://blog.csdn.net/zhaoyangjian724/article/details/26347351

版权

sql 查询优化专栏收录该内容

203 篇文章 34 订阅 ¥39.90 ¥99.00

订阅专栏

博客讨论了在Oracle中使用to_char函数处理CASEID字段导致的索引不被利用的问题。通过去除to_char，优化查询，使得数据库能够正确使用索引，从而提高查询效率。

摘要由CSDN通过智能技术生成

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		| WORKITEM_HISTORY |
|*  4 |   SORT JOIN			|		   |
|   5 |    VIEW 			| VW_NSO_1	   |
|   6 |     SOR

了解本专栏

scan724

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
2
评论
to_char函数引发的不走索引

SQL> conn cowork_czsh/cowork_czshConnected.SQL> set linesize 200SQL> set pagesize 200SQL> set autot traceSQL> select workitemhi0_.PERFORMER as col_0_0_ from WORKITEM_HISTORY workitemhi0_ where
复制链接

扫一扫