The vertical partitioning storage engine merges tables for vertical partitioning and joins by primary key. You can use Vertical Partitioning Storage Engine like following samples. --- Performance tuning sample --- (select col_d from tbl_a) Before partition create table tbl_a( col_a int primary key, col_b int, col_c int, col_d int, col_e varchar(255), col_f text, key idx_a(col_b, col_c), key idx_b(