13. Updating Data : MODIFY...TO COMBINE Statement--Merge and Update Data : Propagate In-memory Updates to Disk
 
Share this page                  
Propagate In-memory Updates to Disk
During batch operations Vector automatically propagates the changes buffered in memory to the disk-resident table.
To do this manually, use the MODIFY...TO COMBINE statement. Doing so frees this memory, which is shown as memory.update_allocated in the vwinfo output.
Use the following SQL statement:
MODIFY table_name TO COMBINE