An ETL/ODBC application is inserting 1 million records in a single transaction against the
PureData System for Analytics. 1 million individual INSERT SQL statements are generated.
What can make this faster?
A.
“Use a COPY command.
B.
“Use an EXTERNAL TABLE.
C.
“Increase the Socket Buffer Size.
D.
“Set the COMMIT interval to 10,000.
Explanation: