Faster map unnesting #11851
Closed
soerenwolfers
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
NOTE: I started writing this as a request for faster unnesting, but as I wrote this I ended up with a quite nice lateral join solution and I'm posting it so I don't forget and so it possibly helps others facing the same task. Also, I'd still be interested in other solutions, especially since the lateral join is nice but the "SELECT ... UNION ALL SELECT" is quite verbose.
I have a table of X values and wish to copy each row a few times, adjoining a different Y value to each copy.
The
unnest
solutionsand
are orders of magnitude slower than the equivalent lateral join
MWE
Beta Was this translation helpful? Give feedback.
All reactions