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:
- What Does Database Designer Do? (Administrator's Guide) gives an overall view of what Database Designer does for your database.
- Results of Running Database Designer (Administrator's Guide) explains what benefits your database achieves by running Database Designer.
- Exporting the Optimized Database (in this guide) contains information about how to deploy the optimized projections when the database is embedded with your application.
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.