IBM
P2090-047 · Question #59
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…
The correct answer is B. Use an EXTERNAL TABLE. See the full explanation below for the reasoning.
Question
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?
Options
- AUse a COPY command.
- BUse an EXTERNAL TABLE.
- CIncrease the Socket Buffer Size.
- DSet the COMMIT interval to 10,000.
How the community answered
(55 responses)- A11% (6)
- B78% (43)
- C7% (4)
- D4% (2)
Community Discussion
No community discussion yet for this question.