Why is generating statistics on a table important to query performance?
A. The table statistics are used to facilitate dislespace reclamation of deleted rows
B. The optimizer uses statistics to determine the optimal execution plan for queries
C. The zone map information cross references the table statistics for each column to avoid scanning
D. The Field Programmable Gate Array (FPGA) utilizes the statistics to identify which rows/columns to filter
|
Download Printable PDF. VALID exam to help you PASS. |
 |