Domanda di colloquio di Docnet

How would you optimise a poorly performing query (in MySQL)?