Pergunta de entrevista da empresa Xero

How would you optimise a stored procedure?