Improved Data-Load Performance

Adaptive Server® improves the ins_by_bulk optimizer criteria, providing faster data loading by using parallel index updates for insert statements into a datarows-locked table with non-clustered indexes.

Enabling the data-load optimization criteria with set ins_by_bulk runs subsequent insert...select statements using bulk insert methods.

In this update, Adaptive Server provides enhancements to improve the performance of data loads via the insert statement to datarows-locked tables with two or more non-clustered indexes. Index updates are done in parallel to speed up the performance of the data load.

• Data-Load Optimization on Tables with Multiple Indexes
  Data-load optimization on a target table that has multiple indexes efficiently loads data pages and maintains multiple indexes in parallel.
• Restrictions
  Data load using parallel index updates optimization is unavailable in certain scenarios.
• Downgrade Considerations
  Transaction logs generated by the data-load optimizations and parallel index updates are incompatible with versions of Adaptive Server earlier than 15.7 SP110. Database and transaction log dumps that are generated with data-load optimizations and parallel index updates cannot be recovered by earlier versions.
• Troubleshoot
  Troubleshoot common situations that may cause bulk insert optimizations to not be applied.