DESIGNER_SET_DESIGN_TYPE

Specifies whether Database Designer creates 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.

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

For more information, see Design Types.

Privileges

Non-superuser: design creator

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)

See Also

Running Database Designer Programmatically