Reading this document I see I should be able to use ins_by_buk to potentially increase performance of inserts.
According to the doc, running
set showplan on
set ins_by_bulk on
then running a insert into <> select * from <>
I should see
The INSERT OPERATOR (VA = 4) is using BULK INSERT
I don't see this at all.
I've tried this on with inserting 1,000,000 rows
Adaptive Server Enterprise/16.0 SP02 PL02/EBF 26143 SMP
Adaptive Server Enterprise/15.7/EBF 24647 SMP SP134
niether show a line indicating a BULK INSERT