Bulk Loading Improvements
Several improvements make it easier to bulk load data:
• The CSV and SSV delimiters allow the COPY statement to read and write files with comma-separated values (CSV).
• COPY FROM an ordinary text data file is up to two times faster.
• A COPY FROM that loads a partitioned table can now perform bulk-load into partitions that satisfy the standard bulk-load criteria.
A related feature,
Batch Query Execution (see page
Batch Query Execution), improves the efficiency of loading data from a client interface.
For more information, see these sections in the SQL Reference Guide:
• Delimiters in the Data File
• CSV and SSV Delimiters