Amazon Redshift’s UDF
Bence Faludi

Thanks for the great write-up on UDFs in Redshift Bence. Have you tried DISTSTYLE ALL for your small join table?

The default DISTSTYLE is EVEN which would be counterproductive for a small join table and would incur unnecessary shuffling and network I/O.

Have you tested on a single-node or multi-node dc1 (SSD) cluster?