Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

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?
A . REORG TABLE sales AND INDEXES ALL; RUNSTATS ON TABLE sales AND INDEXES ALL;
B . REORG TABLE sales INPLACE; REORG INDEXES ALL FOR TABLE sales; RUNSTATS ON TABLE sales AND INDEXES ALL;
C . RUNSTATS ON TABLE sales AND INDEXES ALL; REORGCHK ON TABLE sales;
D . RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

View Answer

Answer: B