Community

MySQL Partition pruning Explained

(Aakash Muthuramalingam) Partitioning is a process in which a single larger table is split into several smaller tables (physically) and still considered as a single table.It is generally a good idea for the tables whose size is in a few 100 GB’s.