Locking Scheme and Fast bcp

Regardless of the locking scheme, any table without indexes can utilize fast bcp.

For:

  • APL tables – the index must be nonunique and nonclustered to enable fast bcp.

  • DOL tables – the index need only be nonunique for fast bcp. It can be either clustered or nonclustered.

To access fast bcp, set sp_dboption 'select into/bulkcopy/pllsort to true in the database.

SAP recommends that you enable dboption "trunc log on chkpt" before using bcp. This ensures that the log will be truncated with each checkpoint. The SAP ASE server issues a checkpoint with each batch completion. To implement more checkpoints, run bcp -b batchsize.