In earlier versions, Adaptive Server used fast bcp when sp_dboption 'select into/bulkcopy/pllsort' was enabled and the table had no indexes or triggers.
In all other cases, Adaptive Server used slow bcp.
If a table had indexes or triggers, you had to drop these before using fast bcp and then recreate them after loading the data with bcp.
Adaptive Server version 15.0.2 allows you to use fast bcp to copy data into tables with non-clustered indexes or triggers, improving Adaptive Server’s performance for inserting huge volumes of data. With this optimization the use of slow bcp is now only required when:
sp_dboption ‘select into/bulkcopy/pllsort’ is off.
sp_dboption ‘select into/bulkcopy/pllsort’ is on, but the table uses the allpages locking scheme and has a clustered index.
sp_dboption ‘select into/bulkcopy/pllsort’ is on, but the table has a unique nonclustered index.
If the option ignore_dup_key option is enabled on the unique index, performing fast bcp can put the table and index in an inconsistent state if rows with duplicate keys are inserted. To avoid the inconsistency, Adaptive Server performs slow bcp.
If the table has nonclustered indexes or triggers, and the table is marked for replication or the database is used as a warm standby.
Because fast bcp does not log inserts, if Adaptive Server uses fast bcp, the rows bcp copies cannot be recovered on the replication site if there is a problem. Adaptive Server uses slow bcp in these situations to maintain compatibility with applications that were written to use the old behavior.
In all other cases, Adaptive Server uses fast bcp.
These are situations in which Adaptive Server version 15.0.2 uses fast bcp but earlier versions Adaptive Server used slow bcp (in all cases sp_dboption ‘select into/bulkcopy/pllsort’ is enabled and the table does not have a clustered index):
When the table has a non-unique, nonclustered index. Adaptive Server logs the index updates and the page allocations only. It does not log inserts into the table.
When a table has triggers. However, bcp does not fire any triggers in the target table.
When a table has datarows or datapage locking scheme with a clustered index.
If the table includes nonclustered indexes or triggers, but sp_dboption 'select into/bulkcopy/pllsort' is not enabled, Adaptive Server uses slow bcp, and prints this warning message to indicate that you can improve the performance of bcp by enabling sp_dboption 'select into/bulkcopy/pllsort':
Performing slow bcp on table '%s'. To enable fast bcp please turn on 'select into/bulkcopy' option on the database '%s
bcp optimizatin is performed by Adaptive Server and does not require that you use Open Client version 15.0 or later.
