PrepAway - Latest Free Exam Questions & Answers

Which of the following activities must be performed first in order to compress the existing index IX1?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Copy the index.

B.
REBUILD the index.

C.
Compress the tablespace.

D.
ALTER the index to use a page size larger than 4K.

Explanation:


Leave a Reply