Intersect in Cache Database

Question

Question

Jude Mukkadayil · Mar 12, 2020

#SQL #Caché

Hi,

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

Thanks for suggestions.

thanks

Jude

Discussion (2)2

Log in or sign up to continue

Laura Cavanaugh · May 19, 2020

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.

0 0

score 2 · Answer 1 · 2020-03-13T09:41:54-04:00

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?

Intersect in Cache Database

Social networks

InterSystems resources