We are building a Loyalty system where the data is centered around the customer. We have the customer, all his transactions and the loyalty points derived from the transactions. The volume is expected to be more than 14 million customers and point transactions more than 30-40 million.
In such a scenario, if I want to partition the tables of customer, his transaction and point tables, which strategy is better.