Designing Projections

Vertica recommends that you use Database Designer to design your physical schema, by running it on a representative sample of your data. Database Designer generates SQL for creating projections that provide maximum performance, as follows:

  1. Analyzes your logical schema, sample data and sample queries (optional).
  2. Designs a physical schema in the form of a SQL script that you can deploy automatically or manually.

Database Designer designs projections that provide excellent query performance within physical constraints. Database Designer uses sophisticated strategies to provide excellent ad-hoc query performance while using disk space efficiently. If desired, you can also design custom projections.