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.