Legal & General interview question

I was asked about database optimisation.