The copy command writes the data continuously to a WOS container. When the WOS container is full, the copy command writes the data to a ROS container.

Select this method when you want to write multiple data sets that are lesser than 100 MB in size. Since the WOS container does not compress and index data, you can write multiple data sets at high speed and then consolidate the data sets into a ROS container.

The copy command directly writes the data to a ROS container without writing it first to a WOS container.

Select this method when you want to write data sets that are greater than 100 MB in size, at a time. Since the ROS container compresses and indexes data, you can reduce the disk storage and improve query execution.

The copy command writes the data incrementally to a WOS container. When the WOS container is full, the copy command displays an error and rolls back the entire data load.

Select this method when you have written your initial data and want to write additional data on an ongoing basis. For example, you can write 10,000 to 100,000 rows per transaction into the WOS container.