Pergunta de entrevista da empresa Docnet

How would you optimise a poorly performing query (in MySQL)?