IBM
C2090-312 · Question #127
In determining whether a REORG on an index space would improve performance, which two of the following columns would NOT be needed? (Choose two.)
The correct answer is A. Column CLUSTERING in SYSIBM.SYSINDEXES D. Column LASTUSED in SYSIBM.SYSINDEXSPACESTATS. See the full explanation below for the reasoning.
Question
In determining whether a REORG on an index space would improve performance, which two of the following columns would NOT be needed? (Choose two.)
Options
- AColumn CLUSTERING in SYSIBM.SYSINDEXES
- BColumn LEAFDIST in SYSIBM.SYSINDEXPART
- CColumn CLUSTERRATIOF in SYSIBM.SYSINDEXES
- DColumn LASTUSED in SYSIBM.SYSINDEXSPACESTATS
- EColumns LEAFNEAR and LEAFFAR in SYSIBM.SYSINDEXPART
How the community answered
(60 responses)- A82% (49)
- B2% (1)
- C5% (3)
- E12% (7)
Community Discussion
No community discussion yet for this question.