One of the most common reasons for using table partitioning is to separate data by date. Some RDBMSes support explicit date partitioning, which MySQL does not have in 8.0. However, it is very easy in MySQL to create partitioning based on DATE, TIME, or DATETIME columns.
Using partitions
Partition pruning
One of the best-known optimizations is partition pruning. The concept is relatively simple and is based on the principle: "Do not analyze partitions where there can be no corresponding values". Let's assume you have a partitioned called employees, table defined by the following statement:
Consider an example where you want to get the results of a SELECT command such as the following:
SELECT firstname, lastname...
