PrepAway - Latest Free Exam Questions & Answers

when will the index be compressed?

Given a table that is already compressed, if you create a new index on
that table, when will the index be compressed?

PrepAway - Latest Free Exam Questions & Answers

A.
after running the REORG command against the table and index

B.
immediately after running the CREATE INDEX command

C.
after running the ALTER INDEX… COMPRESS command

D.
after running the ALTER INDEX… COMPRESS command and the REORG command


Leave a Reply