Locking Scheme and Fast bcp

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

For:

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.Adaptive Server issues a checkpoint with each batch completion. To implement more checkpoints, run bcp -b batchsize.