distkey2

redshift=> EXPLAIN UPDATE all_events SET user_id = test_table.user_id FROM test_table WHERE all_events.event_id = test_table.event_id;
                                    QUERY PLAN                                    
----------------------------------------------------------------------------------
 XN Hash Join DS_BCAST_INNER  (cost=12.50..418648749.25 rows=11015 width=71)
   Hash Cond: ("outer".event_id = "inner".event_id)
   ->  XN Seq Scan on all_events  (cost=0.00..1764430.88 rows=176443088 width=63)
   ->  XN Hash  (cost=10.00..10.00 rows=1000 width=16)
         ->  XN Seq Scan on test_table  (cost=0.00..10.00 rows=1000 width=16)