DESIGNER_SET_DESIGN_TYPE

Specifies whether Database Designer should create a comprehensive or incremental design. DESIGNER_SET_DESIGN_TYPE stores the design mode in the DESIGNS table.

If you do not explicitly set a design mode with this function, Database Designer creates a comprehensive design.

Behavior Type

Immutable

Syntax

DESIGNER_SET_DESIGN_TYPE ( 'design‑name', 'mode' )

Parameters

design‑name

Name of the target design.

mode

Name of the mode that Database Designer should use when designing the database, one of the following:

COMPREHENSIVE: Creates an initial or replacement design for all tables in the specified schemas. You typically create a comprehensive design for a new database.
INCREMENTAL: Modifies an existing design with additional projection that are optimized for new or modified queries.

For more information, see Design Types in the Administrator's Guide.

Privileges

One of the following:

Superuser
Design creator

Notes

Incremental designs always inherit the K-safety value of the database.

Examples

The following examples show the two design mode options for the VMART_DESIGN design:

=> SELECT DESIGNER_SET_DESIGN_TYPE(
    'VMART_DESIGN',
    'COMPREHENSIVE');

DESIGNER_SET_DESIGN_TYPE
--------------------------
                        0
(1 row)
=> SELECT DESIGNER_SET_DESIGN_TYPE( 
    'VMART_DESIGN',
    'INCREMENTAL');
 DESIGNER_SET_DESIGN_TYPE
--------------------------
                        0
(1 row)