Significant Performance Degradation with More Conditions

[pawan (Pawan Rawal)]

Can you try replacing the hash index with exact and see if that’s solves the problem. I suppose because of hash we are fetching lot of keys which can be avoided.