MODIFY...TO COMBINE Statement
The MODIFY...TO COMBINE statement is processed against a table and performs the following operations:
• Writes the data from all completed, cached, INSERT/UPDATE/DELETE statements against a table that reside in memory to disk and optimizes the table layout on disk.
• Performs the transactions requested in the arguments to the MODIFY...TO COMBINE statement as bulk operations.
The use of MODIFY...TO COMBINE is also the most efficient way to perform updates and deletes to a large percentage of the data in a table. However, depending on the volume of outstanding changes on a table and whether a table is indexed, the MODIFY...TO COMBINE statement can still be a lengthy operation.
For more information on the use of MODIFY...TO COMBINE, including practical examples, refer to the Vector SQL Language Guide.