How Database Designer Creates a Design
Design Recommendations
Database Designer-generated designs can include the following recommendations:
-
Sort buddy projections in the same order, which can significantly improve load, recovery, and site node performance. All buddy projections have the same base name so that they can be identified as a group.
Note: If you manually create projections, Database Designer recommends a buddy with the same sort order, if one does not already exist. By default, Database Designer recommends both super and non-super segmented projections with a buddy of the same sort order and segmentation.
- Accepts unlimited queries for a comprehensive design.
-
Allows you to analyze column correlations. Correlation analysis typically only needs to be performed once and only if the table has more than DBDCorrelationSampleRowCount (default: 4000) rows.
By default, Database Designer does not analyze column correlations. To set the correlation analysis mode, use DESIGNER_SET_ANALYZE_CORRELATIONS_MODE
-
Identifies similar design queries and assigns them a signature.
For queries with the same signature, Database Designer weights the queries, depending on how many queries have that signature. It then considers the weighted query when creating a design.
-
Recommends and creates projections in a way that minimizes data skew by distributing data uniformly across the cluster.
- Produces higher quality designs by considering UPDATE, DELETE, and SELECT statements.