Bulk Insert - AE SQL Action Property - When to use it

Bulk Insert - As the property name indicate this property is indication that SQL is doing Bulk data insert. This property is for Insert statements. When this property is enable buffering of the rows to be into the record. Buffering of the rows to be inserted will have considerable performance improvement in the Oracle, Microsoft SQLServer, and DB2 Database.

This property should be set when INSERT SQL is called multiple times in the absence of intervening COMMITs.

PeopleSoft Application Engine ignores the Bulk Insert setting in the following situations:

1) SQL is other than an INSERT/VALUES statement that inserts one row at a time. For
instance, the following statements would be ignored: INSERT/SELECT, UPDATE, or
DELETE.
2) SQL does not have a VALUES CLAUSE.
3) SQL does not have a field list before the VALUES clause.