Hands-On High Performance with Spring 5

Vertical partitioning of a table

In the use of vertical partitioning, we split a table with many columns into multiple tables with particular columns. For example, we must not define very wide text or binary large object (BLOB) data columns infrequently queried tables because of performance issues. This data must be placed in a separate table structure, and a pointer can be used in queried tables.

What follows is a simple example of how we can use vertical partitioning on a customer table and move a binary data type column, customer_Image, into a separate table:

CREATE TABLE customer(  customer_ID numeric(10,0) NOT NULL,   accountName character varying(60) NOT NULL,  accountNumber numeric(10,0) NOT NULL,  customer_Image bytea);

Partition data ...