The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.

The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.

Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table
A . REORG TABLE sales INPLACE RESETDICTIONARY
B . REORG TABLE sales INPLACE REBUILDDICTIONARY
C . REORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY
D . REORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY

View Answer

Answer: C