If say partition use on the ID, 100 w table data points, and to do the index date, when I query use date to query will have any effect? Such as I want to check the date line on 150 w, this time table partition and partition in the same table search speed is there a difference?

CodePudding user response:

Partition tend to be quicker, reason is very simple, in a small table (table into sheets of small tables) check data than in a big table,
With the increase of the amount of data, the performance advantage will be more and more obvious,

CodePudding user response:

Partition using the ID, but you query condition that date, this partition is not what meaning,
If you do use date condition, you should consider by date to do partition, in this way can really play to the role of the partition,