IBM
C2090-312 · Question #62
Compression is desired for index IX1. The current definition of IX1 is as follows: CREATE INDEX IX1 ON TAB1 (COL1 ASC) USING STOGROUP STG1 BUFFERPOOL BP1 ; Which of the following activities must be…
The correct answer is D. ALTER the index to use a page size larger than 4K. See the full explanation below for the reasoning.
Question
Compression is desired for index IX1. The current definition of IX1 is as follows: CREATE INDEX IX1 ON TAB1 (COL1 ASC) USING STOGROUP STG1 BUFFERPOOL BP1 ; Which of the following activities must be performed first in order to compress the existing index IX1?
Options
- ACopy the index.
- BREBUILD the index.
- CCompress the tablespace.
- DALTER the index to use a page size larger than 4K.
How the community answered
(28 responses)- A4% (1)
- B4% (1)
- C11% (3)
- D82% (23)
Community Discussion
No community discussion yet for this question.