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:
|
design_type
|
VARCHAR |
Name of the design type. Valid values are:
|
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 |
|
BOOLEAN |
|
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.
|