Why is generating statistics on a table important to query performance?

Question

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

• A
  7% (2)
• B
  82% (23)
• C
  4% (1)
• D
  7% (2)

No community discussion yet for this question.