PrepAway - Latest Free Exam Questions & Answers

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

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

PrepAway - Latest Free Exam Questions & Answers

A.
“The table statistics are used to facilitate disk space 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 row/columns
to filter.

Explanation:


Leave a Reply