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 ...
to query the data after horizontal split, suppose the data of a business is split horizontally, and the monthly records are stored in a table. The data of each table is about 1000w. There are already more than 20 tables, such as table_201606,.,table_201...