D. Features Introduced in Ingres 10.0 : DBMS Server Enhancements : Bulk Loading Improvements
 
Share this page                  
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, 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