Pentana Solutions interview question

How would you optimise a SQL stored procedure.