Skip to Content
0
Former Member
Jun 09, 2016 at 03:42 PM

Does ins_by_bulk work ?

188 Views

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

and

Adaptive Server Enterprise/15.7/EBF 24647 SMP SP134

niether show a line indicating a BULK INSERT