La Redoute Interview Question

What can you do to improve the performance of a SQL script?