Xero interview question

How would you optimise a stored procedure?