Capgemini interview question

How can solve performance bottleneck in redshift