START_REFRESH

START_REFRESH transfers data to projections that are not able to participate in query execution due to missing or out-of-date data.

Syntax

START_REFRESH()

Notes

• All nodes must be up in order to start a refresh.
• A refresh can start when:
  • a new projection is created for tables that already have data
  • recovery has completed
  • the MARK_DESIGN_KSAFE function is called
• If a refresh is already running the function has no effect.
• Shutting down the database ends the refresh.
• To monitor the refresh operation, examine the log files on each node.