Câu 7: C2090-600: IBM DB2 11.1 DBA for LUW

A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in theSALES 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?

1. A. REORG TABLE sales AND INDEXES ALL; RUNSTATS ON TABLE sales AND INDEXES ALL; — đáp án hiện tại
2. B. REORG TABLE sales INPLACE; REORG INDEXES ALL FOR TABLE sales; RUNSTATS ON TABLE sales AND INDEXES ALL;
3. C. RUNSTATS ON TABLE sales AND INDEXES ALL; REORGCHK ON TABLE sales;
4. D. RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;