Need support why signals are having left join with RU_EXECUTION table and due to this the system performance is getting impacted. we are not able to increase system performance pls suggest what can be done to enhance system performance for optimize below configuration
select * from ACT_RU_EVENT_SUBSCR EVT left outer join ACT_RU_EXECUTION EXC on EVT.EXECUTION_ID_ = EXC.ID_ where EVENT_TYPE_ = ‘signal’ and EVENT_NAME_ = ‘ProductOrderItemUpdateEvent’ and ( (EVT.EXECUTION_ID_ is null) or (EVT.EXECUTION_ID_ is not null AND EXC.SUSPENSION_STATE_ = 1) ) and (EVT.TENANT_ID_ = ‘’ or EVT.TENANT_ID_ is null)
pls suggest what can be done.