mysql 索引使用出现过的问题

最新推荐文章于 2024-06-27 10:45:37 发布

耗子1988

最新推荐文章于 2024-06-27 10:45:37 发布

阅读量582

点赞数 1

分类专栏：数据库

本文链接：https://blog.csdn.net/jianghaooo16/article/details/84031253

版权

数据库专栏收录该内容

2 篇文章 0 订阅

订阅专栏

select  F.InvestigationTime  as InvestigationTime,E.user_name  as CreatePer ,case when datatype=1 THEN '回访反欺诈'
when datatype=2  THEN '专项反欺诈' END
datatype ,F.OrderName  as OrderName,'' as pro_instance_id,'' as ORG_ID,FraudConclusion,FraudTypeNew, '' as FK_CUST_CODE,
CASE when (F.STOREID REGEXP '[^0-9.]')=0  then t3.ORG_NAME else   F.STOREID END as ORG_NAME,UserCard,USERNAME
from lbt_audit_antifraud_info A
JOIN  la_t_blacklistforfeedback  F ON CONCAT(A.ID,'')=F.LbtAuditAntifraudID
JOIN jbpm4_biz_tab B ON  A.ID= B.BIZ_INF_ID AND Biz_type in('2010','2011')
JOIN sys_user E  ON  E.ID=F.Investigator
LEFT JOIN sys_org t3 ON   F.CITYID = t3.id

上sql语句

这个语句中都建有索引但是lbt_audit_antifraud_info这个表的id 是int类型， la_t_blacklistforfeedback 的LbtAuditAntifraudID是字符串类型。导致索引无效，查询缓慢！！