GoCardless interview question

Database indexe, partitioning, sharding, join