Enable Data Load Optimization

The optimization criteria ins_by_bulk improves data load performance.

Use ins_by_bulk at the session or query level.

• At the session level – use set ins_by_bulk to set the optimizer criteria for the current session. The syntax is:

  set ins_by_bulk {on | off}

• At the query level – set ins_by_bulk in the abstract plan for a specific insert statement.
  Note: The abstract plan name must be lowercase.

  The syntax is:

  insert into. . . 
  select . . . 
  plan “(use ins_by_bulk on)”

  For example:

  insert into my_salesdetail (stor_id, ord_num, title_id, qty, discount)
  select stor_id, ord_num, title_id, qty, discount from salesdetail
  where qty > 100
  plan '(use ins_by_bulk on)'

You can use either syntax (session level or query level) within a stored procedure.