Programming, Big Data, Redshift, AWS.
EVEN distribution strategy. Keep interleaved sort keys for the parent table & sort keys for the child table. Daily basis run reindexing, vacuuming task to the tables for time being to maintain good health. The reason is 1. Addressing memory issues is our holistic problem. 2. non-business entities