IBM
C2090-312 · Question #83
Unnecessary REORGs of indexes may be avoided by which of the following?
The correct answer is A. Use the SYSIBM.SYSINDEXSPACESTATS table. See the full explanation below for the reasoning.
Question
Unnecessary REORGs of indexes may be avoided by which of the following?
Options
- AUse the SYSIBM.SYSINDEXSPACESTATS table.
- BUse the REPORT utility to determine the degree of organization.
- CUse the CHANGELIMIT keyword when creating an image copy of the index.
- DUse the CHECK INDEX utility to find out if the index needs to be reorganized.
How the community answered
(40 responses)- A73% (29)
- B5% (2)
- C5% (2)
- D18% (7)
Community Discussion
No community discussion yet for this question.