Legal & General Interview Question

I was asked about database optimisation.