DESIGNER_SET_PROPOSE_UNSEGMENTED_PROJECTIONS

Specifies whether a design can include unsegmented projections. Vertica ignores this function on a one-node cluster, where all projections must be unsegmented.

Behavior Type

Immutable

Syntax

DESIGNER_SET_PROPOSE_UNSEGMENTED_PROJECTIONS ( 'design‑name', unsegmented )

Parameters

design‑name	Name of the target design.
unsegmented	Boolean that specifies whether Database Designer can propose unsegmented projections for tables in this design. When you create a design, the `propose_unsegmented_projections` value in system table `DESIGNS` for this design is set to `true`. If `DESIGNER_SET_PROPOSE_UNSEGMENTED_PROJECTIONS` sets this value to `false`, Database Designer only proposes segmented projections for the design.

Privileges

One of the following:

Superuser
Design creator

Example

The following example specifies that Database Designer can propose only segmented projections for tables in the design VMART_DESIGN:

=> SELECT DESIGNER_SET_PROPOSE_UNSEGMENTED_PROJECTIONS('VMART_DESIGN', false);