Troubleshooting Performance
If your application performance is slow, you need to determine whether your application or the Vertica software is causing the problem.
First, evaluate your system for performance issues. If you modify your application, but are still experiencing issues, evaluate your Vertica database for performance issues.
Vertica provides many tools to evaluate the performance of your database. The following sections of the Administrator's Guide describe them in detail:
The Query Optimization section of Analyzing Data gives information about improving the performance of your database queries.