There is a table (partition table) to store data, partition by date, the amount of data in about 12 million or so a day, how to quickly query according to the conditions query quickly and query data, a total of about 3 billion the amount of data, what is the solution, to solve.
CodePudding user response:
Select * from table partition (partition)Where,,,,,,,
Try it in this way, we also often check data volume larger table
CodePudding user response:
Index partitions in parallel,