Vertica Blog

Vertica Blog

queries

Focused young woman working at laptop in office

The Vertica Academy Is Open for Learning

Joy King, VP Product & GTM Strategy, Vertica
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 Vertica Academy, a platform that offers self-paced, technical training...
Passenger balloon floating in blue sky

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 Vertica Analytics Platform 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...

Use MERGE to Update 1 Million Rows in 2 Seconds

Moshe Goldberg, Vertica System Engineer
May 22, 2017

This blog post was co-authored by Yassine Faihe, Michael Flower, and Moshe Goldberg. Updating One Million Records in Two Seconds To illustrate the true power of MERGE, this article describes how we used MERGE to demonstrate Vertica's performance at scale. SQL MERGE statements combine INSERT and UPDATE operations. They are a great way to update...

Batch Exporting Directed Queries

Vertica Technical Team
December 16, 2016

An
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 Kronenberg
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

The Benefits of Single Node Queries

Sumeet Keswani
August 19, 2015

If your organization deals with low latency, high concurrency applications and queries, you can benefit from having as few nodes as possible involved in each query.
Database Server Room

Vertica Best Practices: Identifying Queries for DBD

Sarah Lemaire, Manager, Vertica Documentation
March 26, 2015

The Vertica Database Designer is a tool that analyzes a logical schema definition, sample queries, and sample data, and creates a physical schema (projections) in the form of a SQL script that you deploy automatically or manually. The result is an optimized database with optimal query performance and data compression.

Live Aggregate Projections with Vertica

Steve Sarsfield, Vertica Senior Product Marketing Manager – Partner Ecosystem
July 1, 2014

The Dragline release of Vertica offers an exciting new feature that is unique in the world of big data analytics platforms. We now offer Live Aggregate projections as part of the platform. The impact is that you can really fly through certain types of big data analytics that typically grind down any analytics system.