every amount change of the user is recorded in this table.
website users about 100W, now the table is too big, thought of sub-table, how to divide it?
Table structure!
user id is a 32-bit guid
every amount change of the user is recorded in this table.
website users about 100W, now the table is too big, thought of sub-table, how to divide it?
Table structure!
user id is a 32-bit guid
oracle.
how to partition a table or partition depends on how the table is queried.
from your point of view, if the query must have a user ID, it is suggested to partition according to the user ID HASH; if the time is also required, you can consider using the combination of ID
HASH + CREATE_AT RANGE.