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