Understanding Large-Scale Updates in Amazon Redshift: A Deep Dive into JOINs and Table Management Strategies