Results of Running Database Designer
In most cases, the projections that Database Designer creates provide excellent query performance within physical constraints while using disk space efficiently. Database Designer:
- Recommends buddy projections, which significantly improve load, recovery, and site node performance.
- Automatically rebalances data after you add or remove nodes.
-
Produces higher quality designs by considering UPDATE and DELETE statements.
Database Designer creates two scripts:
- Design script—Contains all the DDL statements that are needed to create the design.
- Deployment script—Contains all the CREATE PROJECTION scripts that are needed to create the projections for the design. The deployment script is a subset of the design script.
Exporting the Optimized Database in this guide describes how to configure these scripts so that you can standardize all customers on the optimal projections. The scripts must be portable to deployments with different numbers of nodes and K-safety levels.