System Tables for Query Performance

Post links to your favorite Vertica related material in this forum

Moderator: NorbertKrupa

Post Reply
User avatar
Site Admin
Site Admin
Posts: 1737
Joined: Sat Jan 21, 2012 4:58 am

System Tables for Query Performance

Post by JimKnicely » Fri Apr 14, 2017 5:11 pm

When analyzing options for query tuning, the first step is to analyze the query plan, as described in Reading Query Plans. The query plan explains how Vertica plans to process the query. The query plan describes the plan that the Optimizer calculates as the least-cost plan based on what projections the query accesses and on the table statistics. But the query plan does not provide any information about how the query actually executes.

Read more here: ... rmance.htm
Jim Knicely


Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Links”

Who is online

Users browsing this forum: No registered users and 1 guest