Vertica Blog

Vertica Blog

Joins

Analyze Mismatched Series with Event Series Joins

Sarah Lemaire, Manager, Vertica Documentation
June 20, 2016

Event series occur in tables with a time column, most typically a TIMESTAMP data type. In Vertica, you perform an event series join to analyze two series in different tables when their measurement intervals don't align, such as with mismatched timestamps.
Modern Database Analytics

Vertica Joins: A Refresher

Sarah Lemaire, Manager, Vertica Documentation
February 23, 2016

As a Vertica user, you know that using joins can improve query performance by combining records from one or more tables. But sometimes, you need to develop complex joins. Vertica supports many different kinds of joins that perform different functions based on your needs.

What Is a Range Join and Why Is It So Fast?

ChuckB
January 20, 2015

Last week, I was at the 2015 Conference on Innovative Data Systems Research (CIDR), held at the beautiful Asilomar Conference Grounds. The picture above shows one of the many gorgeous views you won't see when you watch other people do PowerPoint presentations. One Vertica user at the conference said he saw a ?range join? in...

Optimizing for Merge Join

NorbertK
October 22, 2014

In an earlier post,