IBM
A2090-560 · Question #81
A SELECT statement spends all its time returning 1 billion rows. What can be done to make this faster?
The correct answer is B. Use an EXTERNAL table. See the full explanation below for the reasoning.
Question
A SELECT statement spends all its time returning 1 billion rows. What can be done to make this faster?
Options
- AUse a CURSOR.
- BUse an EXTERNAL table.
- CUse the COPY command.
- DIncrease the PreFetch Count.
How the community answered
(45 responses)- A9% (4)
- B71% (32)
- C16% (7)
- D4% (2)
Community Discussion
No community discussion yet for this question.