Refreshing Projections
CREATE PROJECTION
does not load data into physical storage. If the anchor tables already contain data, run START_REFRESH
to update the projection. Depending on how much data is in the tables, updating a projection can be time consuming. When a projection is up-to-date, however, it is updated automatically as part of COPY
, DELETE
, INSERT, MERGE
, or UPDATE
statements.