La Redoute interview question

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