What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?

A table named MYTABLE contains an XML column and an XML storage object dictionary already exists.

What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?
A . All data, both new and existing, will becompressed.
B . Only new or updated data for XML columns will be compressed.
C . New and existing XML columns will be compressed but other columns remain unchanged.
D . Existing data will remain uncompressed because the RESETDICTIONARY option of the REORG command was not used.

View Answer

Answer: A