Vertica Blog

Vertica Blog

optimization

Redesigning Projections for Query Optimization

Vertica Technical Team
November 9, 2016

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...

Do You Need to Put Your Query on a Budget?

Sarah Lemaire, Manager, Vertica Documentation
July 6, 2016

Before we scare you away with the word "budget", rest assured that after reading this blog, you won?t have to give up your favorite activities or sell your car. What you will be able to do is understand how Vertica resource pool parameters affect query budget.

Which One of These is Not Like the Others?

Sarah Lemaire, Manager, Vertica Documentation
May 17, 2016

With the new guaranteed uniqueness optimization feature in Vertica 7.2.2, Vertica automatically recognizes when a query is accessing columns with unique values and optimizes the query operations that would otherwise be bogged down due to duplicate values.
Three 3D arrows, different colors pointing in different directions

Looking Under the Hood at Vertica Queries

Sarah Lemaire, Manager, Vertica Documentation
March 2, 2016

When you submit a query to Vertica, you want it to execute as quickly and efficiently as possible. The query optimizer creates a plan that is designed to do just that. The directives in the query plan determine your query's run-time performance and resource consumption, but the properties of your projections and the system parameters also impact...