A tool that analyzes a logical schema definition, sample queries, and sample data, and creates a physical schema (projections) in the form of a SQL script that you deploy automatically or manually. The script creates a minimal set of superprojections to ensure K-safety, and, optionally, non-superprojections. In most cases, the projections created by the Database Designer provide excellent query performance within physical constraints.
The Database Designer can create two distinct design types. The design you choose depends on what you are trying to accomplish:
You can also create custom designs if the Database Designer does not meet your needs.
For detailed information, see Creating a Database Design.