How to Use Database Designer to Optimize Vertica Physical Data Model in Six Steps
Maurizio Felici, Field Chief Technologist
June 16, 2023
Vertica provides out-of-the-box a powerful tool to tune its Physical Data Model: Database Designer (DBD from now on). You can run DBD using the Management Console GUI but in this article we will focus on what they call “programmatic interface” (read... plain SQL) and – as practical examples are often more enlightening than “theoretical” documentation...