Planning Your Design
The syntax for creating a design is easy for anyone who is familiar with SQL. As with any successful project, however, a successful design requires some initial planning. Before you create your first design:
- Become familiar with standard design requirements and plan your design to include them. See Design Requirements.
- Determine how many projections you need to include in the design. See Determining the Number of Projections to Use.
- Determine the type of compression and encoding to use for columns. See Data Encoding and Compression.
- Determine whether or not you want the database to be K-safe. Vertica recommends that all production databases have a minimum K-safety of one (K=1). Valid K-safety values are 0, 1, and 2. See Designing for K-Safety.