IBM
C2090-312 · Question #8
What would be a reason for altering the clustering index of a table?
The correct answer is C. To choose a clustering index to favor batch sequential processing. See the full explanation below for the reasoning.
Question
What would be a reason for altering the clustering index of a table?
Options
- ATo increase free space.
- BBecause the clustering index has to match the primary index.
- CTo choose a clustering index to favor batch sequential processing.
- DTo choose a clustering index to promote sequential inserts at the end of the table space.
How the community answered
(20 responses)- A15% (3)
- B5% (1)
- C75% (15)
- D5% (1)
Community Discussion
No community discussion yet for this question.