单选题

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.

查看答案

正确答案：A （备注：此答案有误）

相似试题

判断题

Employers often choose the best candidate.

答案解析
单选题

[音频]Listen to the dialogue and choose the best answer to the question you hear.( )

答案解析
单选题

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

答案解析
单选题

Choose the best answer.How can mysqld_multi be configured to allow MySQL instances to use the same port number?

答案解析
单选题

Choose the best answer.Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

答案解析