Optimizing the Database with Database Designer

An Vertica database stores its data in a physical format called projections. For optimal performance, projections should be optimized based on data and workload characteristics.

As Vertica OEM customers, optimize the projection design during your development cycle.You can standardize on that design for all deployments of your application.

The following sections describe the process of tuning projections using Database Designer:

After you create your database for the first time, load the typical queries and sample data on your development system. Then, create a comprehensive database design as described in Comprehensive Design in the Administrator's Guide.