Pergunta de entrevista da empresa Jabil

How can database queries be optimized either with indices or with denormalization?