Improved Data Load Performance

Adaptive Server 15.7 SP100 improves data load performance by enabling ins_by_bulk optimization criteria, which uses bulk-data row inserts for insert statements.

When you enable data load optimization criteria using the set statement, Adaptive Server then uses that criteria when running subsequent insert...select or batch insert statements. The scope of the statement-level directive enabled via the abstract plan is limited to the statement.

This optimization improves data load performance on the target table.