Bulk copying into a table on Adaptive Server runs fastest when there are no indexes or active triggers on the table. When you are running fast bulk copy, Adaptive Server performs reduced logging.
It does not log the actual changes to the database, only the allocation of pages. And, since there are no indexes to update, it saves all the time it would otherwise take to update indexes for each data insert and to log the changes to the index pages.
To use fast bulk copy:
Drop any indexes; re-create them when the bulk copy completes.
Use alter table...disable trigger to deactivate triggers during the copy; use alter table...enable trigger after the copy completes.
Set the select into/bulkcopy/pllsort option with sp_dboption. Remember to turn the option off after the bulk copy operation completes.
During fast bulk copy, rules are not enforced, but defaults are enforced.
Since changes to the data are not logged, you should perform a dump database soon after a fast bulk copy operation. Performing a fast bulk copy in a database blocks the use of dump transaction, since the unlogged data changes cannot be recovered from the transaction log dump.
