Bulk Copying
To improve performance when loading data from a file into a table, you can use a bulk copy. The requirements for performing a bulk copy are:
• The table is not journaled
• The table has no secondary indexes
• The table is empty and occupies fewer than 18 pages if the table is other than heap
If the DBMS Server determines that all these requirements are met, the data is loading 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 Database Administrator Guide.