• Optimization, Performance Tuning

    Overview of Pre-join Projections


    This post will give an overview of Vertica’s pre-join projections. Pre-join projections are not frequently used due to the manual set up work and limitations around its usage. However, they can deliver increased performance at query execution by moving the join step into the load.

  • News

    Call For Authors


    I’ve set up this site with the goal of becoming a valuable resource for the analytic database known as Vertica. Thus far, it has been a tremendous immersion process to learn and practice this technology. Resources have been extremely scarce and there’s much to share while learning the technology.

Upcoming Events

  • No upcoming events
AEC v1.0.4

Subscribe to Blog via Email

Enter your email address to subscribe and receive notifications of new posts by email.

Read more use cases here.


This site is not affiliated, endorsed or associated with HPE Vertica. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.