Vertica Advanced Performance Tuning

( Duration: 2 Days )

The HP Vertica Advanced Performance Tuning training course provides an intensive deep-dive into the process of diagnosing and optimizing query performance within an HP Vertica deployment. You will learn how to tune and simplify database queries, modify resource settings, monitor and update statistics, and interpret the output of the Workload Analyzer.

Attending HP Vertica Essentials course or equivalent experience with the HP Vertica Analytics platform

System Administrators, Database Administrators, and Application Developers




  • Class Introductions

Advanced Projection Design

  • Database Design, Manual Projection Design, Run Length Encoding, Pre-Join Projections, Live Aggregate Projections, Expressions in Projections

Projection Design for Optimal Queries

  • Database Designer in Incremental Mode, Optimize Joins, Optimize Group By, Correlate Columns, Grouped Columns, High Cardinality Columns

Parameters and Settings

  • guration Parameters, ResourceSystem and Data Collector Tables, Con Management Settings, Dynamic Resource Pool

Query Analysis


Performance Monitoring and Tools

  • Research Longest Running Queries, Workload Analyzer, Delete and Purge, I/O Throughput, Network Performance, CPU Performance, Locks

Query Optimization

  • Restructure Queries, Count Distinct, WITH Clause

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.