IBM
P2090-050 · Question #26
P2090-050 Question #26: Real Exam Question with Answer & Explanation
Sign in or unlock P2090-050 to reveal the answer and full explanation for question #26. 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 P2090-050 to see the answer
You've previewed enough free P2090-050 questions. Unlock P2090-050 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.