Vertica Best Practices: Identifying Queries for DBD

The Vertica Database Designer is 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 result is an optimized database with optimal query performance and data compression.

To allow Database Designer to create an optimal physical schema for your organization, supply Database Designer with representative queries that you run on your database. When you do this, Database Designer optimizes the performance of those queries specifically. Watch this video to learn more about identifying sample queries for Database Designer to consider.