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
  11% (5)
• B
  83% (38)
• C
  2% (1)
• D
  4% (2)

No community discussion yet for this question.