DESIGNS

Contains information about a Database Designer design. After you create a design and specify certain parameters for Database Designer, DESIGNER_CREATE_DESIGN creates this table in the V_MONITOR schema.

Column Name Column Type Description
design_id INTEGER

Unique ID that Database Designer assigns to this design.

design_name VARCHAR

Name that the user specifies for the design.

ksafety_level INTEGER K-safety level for the design. Database Designer assigns a K-safety value of 0 for clusters with 1 or 2 nodes, and assigns a value of 1 for clusters with 3 or more nodes.
optimization_objective VARCHAR

Name of the optimization objective for the design. Valid values are:

  • QUERY
  • LOAD
  • BALANCED (default)
design_type VARCHAR

Name of the design type. Valid values are:

  • COMPREHENSIVE (default)
  • INCREMENTAL
propose_super_first BOOLEAN Specifies to propose superprojections before projections, by default f. If DESIGN_MODE is COMPREHENSIVE, this field has no impact.
design_available BOOLEAN t if the design is currently available, otherwise, f (default).
collected_statistics BOOLEAN t if statistics are to be collected when creating the design, otherwise, f (default).
populate_design_tables_from_queries BOOLEAN t if you want to populate the design tables from the design queries, otherwise, f (default).
encoding_design BOOLEAN t if the design is an encoding optimization design on pre-existing projections, otherwise, f (default).
deployment_parallelism INTEGER Number of tables to be deployed in parallel when the design is complete. Default: 0

propose_unsegmented_projections

BOOLEAN

t if you specify unsegmented projections, otherwise, f (default).

analyze_correlations_mode INTEGER

Specifies how Database Designer should handle existing column correlations in a design and whether or not Database Designer should reanalyze existing column correlations.

  • 0—(default) Ignore column correlations when creating the design.
  • 1—Consider the existing correlations in the tables when creating the design.
  • 2—Analyze column correlations if not previously performed, and consider the column correlations when creating the design.
  • 3—Analyze all column correlations in the tables and consider them when creating the design, even if they have been analyzed previously.