Given a table that is already compressed, if you create a new index on
that table, when will the index be compressed?
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