DESIGNER_SET_OPTIMIZATION_OBJECTIVE

Valid only for comprehensive database designs, specifies the optimization objective Database Designer uses. Database Designer ignores this function for incremental designs.

DESIGNER_SET_OPTIMIZATION_OBJECTIVE stores the optimization objective in the DESIGNS table.

Behavior Type

Immutable

Syntax

DESIGNER_SET_OPTIMIZATION_OBJECTIVE ( 'design‑name', 'policy' )

Parameters

design‑name

Name of the target design.

policy

Specifies the design's optimization policy, one of the following:

  • QUERY: Optimize for query performance. This can result in a larger database storage footprint because additional projections might be created.
  • LOAD: Optimize for load performance so database size is minimized. This can result in slower query performance.
  • BALANCED: Balance the design between query performance and database size.

Privileges

Non-superuser: design creator

Examples

The following example sets the optimization objective option for the VMART_DESIGN design: to QUERY:

=> SELECT DESIGNER_SET_OPTIMIZATION_OBJECTIVE(  'VMART_DESIGN', 'QUERY');
 DESIGNER_SET_OPTIMIZATION_OBJECTIVE
------------------------------------
                                  0
(1 row)

See Also

Running Database Designer Programmatically