Project on a 500 million the amount of data table query up slowly, so I want to do the partition table, so do the table name of DML statements after the partition table needs to be modified?

CodePudding user response:

Don't need to modify

CodePudding user response:

1, do not need;
2, the SQL statement must occur partition clipping, to improve performance, otherwise, it's no use, so, the original poster also have to understand the mechanism and principle of partition,

CodePudding user response:

Unless you want to operate in a statement specific limited partition, otherwise don't need,

CodePudding user response:

Partition table partitioning key design take into account the DML statements of your field, where conditions can really improve the efficiency of query,
If you don't consider the performance, don't need to modify the DML.