Forum Discussion
Optimization of getting intersection between values in same table
Hi guys, I'm stuck with optimization my dashboard. Let's say that i have this piece of data: id values 1 a 1 b 1 b 2 a 2 b 2 c 2 c 3 a 3 b 3 c 3...
Apart from deduplication and calculating only the "top" triangle there is not much you can do. It will be a cartesian product, and with large numbers of values that cartesian will be huge.
What are you planning to do with the result?
Business want to see intersection choosing differents IDs to make any decisions...
I got about deduplication, seems it can reduce amount of rows. But this dataset is only for 1 month period. I assume they will ask me to do the same with 3 month period 🙂