Hi, The most useful information here is the plan that the RDBMS uses. Is it possible to share it?
I suppose that using of either the IDX_ORG_MEDP_DRUG index or the IDX_DRUG_ID index is not absolutely correct. My bet is an index on (DRUG_ID, ORG_ID) could help here but it's to be checked. And it's important to clarify whether you really need a left join here. Inner join would help to use separate "where" clause to have different indexes for the join and for the filtering. What do you think, does it make any sense here? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
