Information Faster Blog

No, You Do Not Need One Projection Per Query in Vertica

Projections are powerful.

 

Projections are the Vertica Analytic Databases’s only data structure. Every row from every table stored in Vertica is stored in a projection.

 

Continue reading to find out why there is no such thing as a query which “does not hit the projections.”

 

Guest post by Andrew Lamb, Vertica Senior Engineer

Search
Showing results for 
Search instead for 
Do you mean 
About the Author(s)
  • This account is for guest bloggers. The blog post will identify the blogger.
  • For years I've been doing video and music production back and forth between Boston MA and New Orleans LA. Starting in 2010, I've began working with Vertica (now HP Vertica) in the marketing team, doing customer testimonials, product release videos, and website management. I'm fascinated by Big Data and the amazing things my badass team at HP Vertica has done and continues to do in the industry every day.
Follow Us


HP Blog

HP Software Solutions Blog

Labels
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation