Bulk Copying
To improve performance when loading data from a file into a table, use a bulk copy. Bulk copy is possible for either formatted or unformatted copies.
The requirements for performing a bulk copy are:
• The table is not journaled
• The table has no secondary indexes
• For storage structures other than heap, the table is empty and occupies fewer than 18 pages
If the DBMS Server determines that all these requirements are met, the data is loaded using bulk copy. If the requirements are not met, data is loaded using a less rapid technique. For detailed information about bulk copying, see the Ingres Database Administrator Guide.
To specify the estimated number of rows to be copied from a file to a table during a bulk copy operation, use
with row_estimate (see
Row_estimate).