High CPU or memory grants when using optimized nested loop or batch sort Provides a resolution for high CPU and memory usage when you run queries with optimized nested loop or batch sort operators.

When running the statement in relations.sql, our Redshift cluster query planner will, seemingly at random, expect to use a nested loop join. This reflects in extended execution times, adding anywhere ...