Capgemini Interview Question

How can solve performance bottleneck in redshift