We have one large table with 100 million records and its size is 100 GB and data is continuously growing day by day. This table has 30 partitions with
RANGE by client_id(table's column). One
client_id is having minimum 1 million records.
For solution we have break this large table into 30 small tables with group of
client_id data in each table. Now we want to do partition in each table.
- So which partition would work for us best: Range or Hash?
We don't know which table has which set of