Walgreens Interview Question

The question was how would you efficiently query a database that is denormalized?