query Archives | Vertica

Create Read Update Delete in red 3D letters surrounded by 3D ones and zeroes

Vertica 9.3 Supports UPDATE and DELETE Operations on Tables Having Live Aggregate Projections!

Jim Knicely, Vertica Principal Solution Architect
October 17, 2019

A live aggregate projection contains columns with values that are aggregated from columns in its anchor table. When you load data into the table, Vertica aggregates the data before loading it into the live aggregate projection. On subsequent loads (for example, through INSERT or COPY) Vertica recalculates aggregations with the new data and updates the...

Focused young woman working at laptop in office

The Vertica Academy Is Open for Learning

Joy King, VP, Vertica Product Management & Product Marketing
September 9, 2019

One of the greatest impacts from digital transformation, both from a personal and professional point of view, is not just the democratization of data - a very popular topic here at Vertica! - but the democratization of knowledge. Today, we are excited to announce the new, a platform that offers self-paced, technical training and certifications...

Announcing Vertica Version 9.2.1 – Take Analytics Efficiency to the Next Level

Paige Roberts, Vertica Open Source Relations Manager
May 10, 2019

This week, some very cool things have gone into the newest version of the that make your analytics fly and save on your AWS budget. The theme for this release is Improving Vertica in Eon Mode Integration with Amazon S3, and there are a whole bunch of new features designed to do exactly that. But,...

The Life of a Query, According to Henry Ford

Vertica Technical Team
January 10, 2017

While Henry Ford did not in fact develop or even patent the modern assembly line (that credit goes to Ransom E. Olds), he relied heavily on the process for automobile production."

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

Troubleshooting Vertica Query Performance with System Tables

Sarah Lemaire, Manager, Vertica Documentation
August 29, 2016

Do you want to learn how to troubleshoot your query performance issues? We've got you covered. Just attend at Vertica's Big Data Conference."

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.

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

Tell the Optimizer You Have a Better Plan

Michael
December 17, 2015

You're upgrading your database and some query appears to execute less efficiently than before. What can you do? Vertica addresses this concern in Vertica 7.2 with directed queries

Using JDBC Routable Query API for High Concurrency and High Throughput

Shubhangi
September 14, 2015

Does your organization use high-volume short requests that return a small number of results on a single node? Do you deal with low latency and high concurrency queries, and want to achieve high throughput? You could benefit by using the Vertica JDBC Routable Query API that uses fewer system resources than distributed queries.

Vertica Blog

query