为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:SF_INJECT_HINT(' ', 'ENABLE_HASH_JOIN(0)', 'test_INJECT', 'to list query2', TRUE, NULL);
长sql语句如何添加进去呢 例如这个语句如何添加进去 全部添加无法执行
SELECT count(1) AS "At"
FROM ( SELECT DISTINCT T0.cName AS name,
T0.contactName AS contactName,
T0.contactTel AS contactTel,
T0.cEnterpriseName AS enterpriseName,
T0.cPersonName AS personName,
T0.cOrgName AS orgName,
T0.transType AS transType,
T5.searchCode AS "merchantAppliedDetail!searchcode",
T5.cSpecialManagementDep AS "merchantAppliedDetail!specialManagementDep",
T6.id AS merchantApplyRangeId,
T6.orgId AS belongOrg,
T6.orgId AS "merchantAppliedDetail!belongMerchant",
T2.cMerchantOptions AS "merchantRole!merchantOptions",
T2.cBusinessRole AS "merchantRole!businessRole"
FROM A.B T0
LEFT JOIN A.C T5
ON T5.id = T0.id
AND T5.ytenant_id = 'rlcu7kep'
LEFT JOIN A.D T6
ON T6.id = T5.merchantApplyRangeId
AND T6.ytenant_id = 'rlcu7kep'
AND T6.ispotential = 0
LEFT JOIN iuap_apdoc_coredoc.merchantroleinfo T2
ON T2.imerchantId = T0.id
AND T2.ytenant_id = 'rlcu7kep'
WHERE T0.id IN (2393860315440742415,
2392977330273255433,
2392992250989641741,
2393947417377505282,
2393946601333720052,
2393964734685642782,
2392798127057798119,
2392977330273255434,
2393019884809224199,
2393062482294865923,
2393947374427832346)
AND (T5.stopstatus = 0
AND T5.stopstatus = 0
AND T6.orgId IN ('2392345952922370057')
AND T5.stopstatus = 0
AND T6.iRangeType = 1)
AND T0.ytenant_id = 'rlcu7kep' ) t
这种求count的语句为何要禁HASH,感觉优化思路有点歪了,如果有性能问题,建议把语句和执行计划等信息发出来,大家帮忙诊断一下

确保启动hint注入功能ENABLE_INJECT_HINT=1
select para_name,para_name from v$dm_ini where para_name='ENABLE_INJECT_HINT';
call sf_inject_hint('关键sql语句部分',
'要注入的优化参数信息','此hit注入的命名',null,true,null);