Jude Mukkadayil · Mar 12, 2020

Intersect in Cache Database


        What is the alternative for INTERSECT in cache. I tried Intersect but not working.

Thanks for suggestions.








2 0 2 204


Have you tried using a JOIN to get the desired results?

If you have already tried using a JOIN, what are you seeing that is not expected?

Hi Peter and Jude,

I am also trying to use the idea of INTERSECT. Instead of intersect, I'm using a RIGHT JOIN or a LEFT JOIN, but the query plan isn't using the faster table to loop through the data.

I found that changing the Group By to the table that I want the query plan to use for the loop, made it much faster.