Oracle
1Z0-908 · Question #42
Which statement is true about InnoDB persistent index statistics?
The correct answer is D. Execution plans based on transient index statistics improve precision when. https://mariadb.com/kb/en/innodb-persistent-statistics/
Performance Tuning
Question
Which statement is true about InnoDB persistent index statistics?
Options
- AUpdating index statistics is an I/O expensive operation.
- BIndex statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage
- CSetting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new
- DExecution plans based on transient index statistics improve precision when
- EIncreasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at
- FTables are scanned and index statistics recalculated when an instance is restarted.
How the community answered
(31 responses)- A3% (1)
- B10% (3)
- D84% (26)
- E3% (1)
Explanation
Topics
#InnoDB statistics#innodb_stats_persistent_sample_pages#index statistics#execution plans
Community Discussion
No community discussion yet for this question.