Performance Considerations Sybase defines two bulk copy modes, described in the following table. Sybase automatically selects the appropriate mode at run time. For more information, refer to your Sybase documentation. Table 39. Summary of Fast and Slow Bulk Copy Mode Characteristics Characteristic Fast Bulk Copy Mode Slow Bulk Copy Mode Destination Table Characteristics No indexes or triggers on destination table One or more indexes or triggers Database Configuration Required The into/bulkcopy/pllsort dboption must be set to true. None Logging Performed Page allocations are logged, but row inserts are not Row inserts are logged Transaction Log Handling You must dump the database before backing up (dumping) the transaction log. The transaction log can become very large. After the bulk copy completes, back up your database with dump database, then truncate the log with dump transaction.