为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:--03134284488-20260212-314192-20200
【操作系统】:麒麟
【CPU】:ARM
【问题描述】*:多表关联查询高并发压测效率慢,压测结果6s+
select kmimissive1_.fd_id
from km_imissive_receive_main kmimissive1_
cross join lbpm_history_workitem lbpmhistor2_
inner join sys_org_element sysorgelem3_
on lbpmhistor2_.fd_handler_id = sysorgelem3_.fd_id
inner join lbpm_process lbpmproces4_
on lbpmhistor2_.fd_process_id = lbpmproces4_.fd_id
where kmimissive1_.fd_id = lbpmproces4_.fd_id
and sysorgelem3_.fd_id = ?
and lbpmhistor2_.fd_activity_type <> 'draftWorkitem';
1 #NSET2: [36, 3882->45120, 240]
2 #PRJT2: [36, 3882->45120, 240]; exp_num(1), is_atom(FALSE); INFO_BITS(0)
3 #NEST LOOP INNER JOIN2: [36, 3882->45120, 240];
4 #SSEK2: [1, 1->1, 48]; scan_type(ASC), INDEX33561563(SYS_ORG_ELEMENT), is_global(0), scan_range[exp_param(no:0),exp_param(no:0)]
5 #NEST LOOP INDEX JOIN2: [18, 3882->45120, 192]
6 #SLCT2: [1, 3882->77517, 144]; (NOT(LBPMHISTOR2_.FD_PROCESS_ID IS NULL) AND LBPMHISTOR2_.FD_ACTIVITY_TYPE <> 'draftWorkitem'), slct_pushdown(0)
7 #SSEK2: [1, 3882->77686, 144]; scan_type(ASC), IDXC28595BBC0FBE451(LBPM_HISTORY_WORKITEM), is_global(0), scan_range[(exp_param(no:0),min,min),(exp_param(no:0),max,max))
8 #SSEK2: [17, 1->45120, 48]; scan_type(ASC), INDEX33559272(KM_IMISSIVE_RECEIVE_MAIN), is_global(0), scan_range[LBPMHISTOR2_.FD_PROCESS_ID,LBPMHISTOR2_.FD_PROCESS_ID]
Statistics
276714 logical reads
0 physical reads
0.000 io wait time(ms)
602.346 exec time(ms)
SSEK2 26 0% 9 4 2 0 0 0 0 null null 0 null
DLCK 62 0.01% 8 0 7 0 0 0 0 null null 0 null
SLCT2 1890 0.33% 7 6 610 0 0 0 0 null null 0 null
SSEK2 9989 1.77% 6 7 305 0 0 0 0 null null 0 null
PRJT2 10582 1.87% 5 2 90242 0 0 0 0 null null 0 null
NLI2 12352 2.18% 4 3 90244 0 0 0 0 null null 0 null
IJI2 17307 3.06% 3 5 168063 0 0 0 0 null null 0 null
NSET2 124263 21.97% 2 1 45127 0 0 0 0 null null 0 null
SSEK2 389076 68.8% 1 8 122637 0 0 0 0 null null 0 null
INDEX33559272这个索引是哪个字段的?

查询下ENABLE_HASH_JOIN参数值是多少,添加上hint,/+ENABLE_HASH_JOIN(1)/执行看看