Vertica Analytics Platform Version 9.2.x Documentation

Working with Projections

Unlike traditional databases that store data in tables, Vertica physically stores table data in projections, which are collections of table columns.

Projections store data in a format that optimizes query execution. Similar to materialized views, they store result sets on disk rather than compute them each time they are used in a query. Vertica automatically refreshes these result sets with updated or new data.

Projections can be generally classified in two ways:

For more general information about Vertica projections, see Physical Schema in Vertica Concepts.

In This Section