Segmentation

Defines how physical data storage (projections) is stored in a database cluster using the CREATE PROJECTION statement.

Defines how physical data storage (projections) is stored in a database cluster using the CREATE PROJECTION statement. The goal is to distribute data evenly across multiple nodes in the database so that all nodes can participate in query execution.

Note

Partitioning and segmentation are terms often used interchangeably for other databases, but they have completely separate goals in Vertica regarding data localization. See Partitioning and segmentation in the Administrator's Guide for details.