Choose the best answer.Which statement is true about InnoDB persistent index statistics?A、Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.B、Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.C、Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDBStorage engine.D、Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created more than 10% of its rows.E、Updating index statistics is an I/O expensive operation.-易过题库-题库最全的搜题网站

Choose the best answer.Which statement is true about InnoDB persistent index statistics?

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

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

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

DSetting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created more than 10% of its rows.

EUpdating index statistics is an I/O expensive operation.

试题详情