Partition Pruning & Management
Learn Partition Pruning & Management (Partitioning, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction Partition pruning is the optimizer skipping partitions that cannot contain matching rows, based on the WHERE clause. Management means adding, dropping, splitting, exchanging and rebuilding partitions with ALTER TABLE.