IBM
C2090-600 · Question #44
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…
The correct answer is A. REORG TABLE sales AND INDEXES ALL. See the full explanation below for the reasoning.
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;
How the community answered
(43 responses)- A74% (32)
- B14% (6)
- C2% (1)
- D9% (4)
Community Discussion
No community discussion yet for this question.