Redesigning Projections for Query Optimization

Post links to your favorite Vertica related material in this forum

Moderator: NorbertKrupa

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

Redesigning Projections for Query Optimization

Post by JimKnicely » Wed Mar 29, 2017 1:05 am

When you submit a query to Vertica, the Vertica query optimizer automatically assembles a query plan, which consists of a set of operations to compute the requested result. Depending on the properties of the projections defined in your database, the query optimizer can choose faster and more efficient operations. Thus, it’s important to recognize what you can do to optimize your projections to improve query performance.

Read more here: ... zation.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