PrepAway - Latest Free Exam Questions & Answers

Which of the following commands should be used by the D…

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?

PrepAway - Latest Free Exam Questions & Answers

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;


Leave a Reply