Bulk insert

Bulk inserts of data can improve the performance of insert operations to the Netezza data source.

Federation supports bulk inserts of data to the Netezza data source based on the evaluation of the insert operation.

Federation automatically performs bulk inserts when the insert operation includes a source table or includes multiple values for the INSERT operator in the access plan. A bulk insert is typically chosen if you insert data to a Netezza nickname by using the following insert operations:

Insert data to Netezza from a result set of sub-query as shown in the following example:
```
INSERT INTO n1 SELECT c1, c2 FROM local_t1;
```
Insert more than one value into Netezza as shown in the following example:
```
INSERT INTO n1 VALUES (1, 'a'), (2, 'b');
```

To enable bulk insert, set the ODBC server option ENABLE_BULK_INSERT to Y.