Using Database Designer to Create a Comprehensive Design

The Vertica Database Designer:

Use Database Designer to create a comprehensive design, which allows you to create new projections for all tables in your database.

You can also use Database Designer to create an incremental design, which creates projections for all tables referenced in the queries you supply. For more information, see Incremental Design in the Administrator’s Guide.

You can create a comprehensive design with Database Designer using Management Console or through Administration Tools. You can also choose to run Database Designer programmatically (See About Running Database Designer Programmatically).

This section shows you how to: