There is such a scenario, the base of meal ordering relations (110 million data), Oracle database, single table, now with the relationship between the activity/gift bag, an activity/gift bag contains more than one package, there are optional and will choose package, ordered corresponding choice set user rules determine to participate in the activities of users, now has 3000 active relationship with the combination of the package, for quick meal ordering relations from 110 million list, the order of user marking, to mark out the corresponding optional packages and will choose package type,
As simple as possible, execution efficiency as soon as possible