Such as a table to store 1.3 billion staff basic information, in order to be able to quickly query, partitioning is a way or use table partitioning method? Which query speed? Why is that?

CodePudding user response:

This depends on your partition columns and query conditions, the partition table is much more flexible form and than

CodePudding user response:

reference 1st floor wmxcn2000 response:

this column to see your partitions and query conditions, the partition table is much more flexible form and than

+ 1
Depends on the needs of the business,
Routine, or suggest using the partition table, unless the business is clear, generally do not recommend the watch separated, such as your partition table according to the provinces, and then according to the age of the query; You age segmentation, and according to the degree of the demand of the query,

CodePudding user response:

Query to check all the data must be in one partition table speed, but if there is a button at the front desk to distinguish the condition to control must watch cutting fast, because of the small table,