Question d’entretien chez Pentana Solutions

How would you optimise a SQL stored procedure.