IBM
C2090-600 · Question #30
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…
The correct answer is C. REORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY. See the full explanation below for the reasoning.
Question
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
Options
- AREORG TABLE sales INPLACE RESETDICTIONARY
- BREORG TABLE sales INPLACE REBUILDDICTIONARY
- CREORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY
- DREORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY
How the community answered
(28 responses)- A7% (2)
- B7% (2)
- C82% (23)
- D4% (1)
Community Discussion
No community discussion yet for this question.