IBM
P2090-050 · Question #85
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
(25 responses)- A4% (1)
- B80% (20)
- C12% (3)
- D4% (1)
Community Discussion
No community discussion yet for this question.