IBM
C2090-600 · Question #44
C2090-600 Question #44: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-600 to reveal the answer and full explanation for question #44. The question stem and answer options stay visible for context.
Question
A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table. Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?
Options
- AREORG TABLE sales AND INDEXES ALL;
- BREORG TABLE sales INPLACE;
- CRUNSTATS ON TABLE sales AND INDEXES ALL;
- DRUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;
Unlock C2090-600 to see the answer
You've previewed enough free C2090-600 questions. Unlock C2090-600 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.