Câu 11: C2090-600: IBM DB2 11.1 DBA for LUW
The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table. Which of…
Nội dung câu hỏi
The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table. Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. REORG TABLE sales INPLACE RESETDICTIONARY
- B. REORG TABLE sales INPLACE REBUILDDICTIONARY
- C. REORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY — đáp án hiện tại
- D. REORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.