IBM
A2090-560 · Question #124
A2090-560 Question #124: Real Exam Question with Answer & Explanation
Sign in or unlock A2090-560 to reveal the answer and full explanation for question #124. The question stem and answer options stay visible for context.
Question
Why is generating statistics on a table important to query performance?
Options
- AThe table statistics are used to facilitate disk space reclamation of deleted rows.
- BThe optimizer uses statistics to determine the optimal execution plan for queries.
- CThe Zone Map information cross references the table statistics for each column to avoid
- DThe Field Programmable Gate Array (FPGA) utilizes the statistics to identify which row/columns
Unlock A2090-560 to see the answer
You've previewed enough free A2090-560 questions. Unlock A2090-560 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.