MySQL 8 Administrator???s Guide

Partition selection

Explicit selection of partition and subpartition is also supported and this enables row matching to conditions given in the where clause - this is known as partition selection. It is very similar to partition pruning as only specific partitions are scanned for matching, but differs in the following two key aspects:

• The partitions to be scanned are specified by the issuer of the statement and are not automatic such as with partition pruning
• The partition pruning is limited to queries, whereas partition selection supports both queries and a number of DML statements

SQL statements supported for explicit partition selection are listed as follows:

• INSERT
• SELECT
• UPDATE
• REPLACE
• LOAD DATA
• LOAD XML
• DELETE

The following syntax ...