Query Optimization Using Projections

Moderator: NorbertKrupa

Post Reply
User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1778
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Query Optimization Using Projections

Post by JimKnicely » Wed May 24, 2017 4:48 pm

Another great blog post!

In Vertica, tables are logical representations of the data. Vertica stores the actual data in projections. When data is loaded into a Vertica table, Vertica creates or updates a column-store projection. Vertica also compresses and/or encodes projection data, optimizing data access and storage.

If you experience performance issues, your best first step is to run Database Designer with sample queries and sample data. Database Designer creates projections that are optimized for those queries and data.

Learn more here: https://my.vertica.com/blog/query-optim ... ojections/
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Links”