6. QUEL and EQUEL Statements : Copy Statement--Copy Data : Copy Statement Parameters : Bulk Copying
 
Share this page                  
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.