Question d’entretien chez Zendesk

How would you optimise a slow SQL query?