Pregunta de entrevista de Legal & General

I was asked about database optimisation.