Examice

Exam 1z0-908 All QuestionsBrowse all questions from this exam

Question 141

Which statement is true about InnoDB persistent index statistics?

Updating index statistics is an I/O expensive operation.

Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.

Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.

Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.

Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.

Correct Answer: C

Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created. This is a true statement about InnoDB persistent index statistics. Persistent index statistics in InnoDB are aimed at avoiding the need to recalculate index statistics constantly, and having the auto recalc option set to ON ensures the statistics are kept accurate without manual intervention whenever changes such as a new index creation occur.

Discussion

LrnsTgh

this question is the same with Question #5. D is not about persistent indexed. E might be the answer but not sure.

marklvOption: D

D I think