A. Updating index statistics is an I/O expensive operation.
When InnoDB updates index statistics, it requires scanning the data pages on disk to calculate the statistics, which can be I/O-intensive, particularly if the table is large. The more pages InnoDB has to scan, the more expensive the operation becomes.
D
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_stats_persistent_sample_pages
The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE. [Increasing the value improves the accuracy of index statistics, which can improve the query execution plan], at the expense of increased I/O during the execution of ANALYZE TABLE for an InnoDB table.
Not C
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_stats_auto_recalc
This setting applies to tables created when the innodb_stats_persistent option is enabled.
A.
C is not correct because it mentions: "The innodb_stats_auto_recalc variable, which is enabled by default, controls whether statistics are calculated automatically when a table undergoes changes to more than 10% of its rows, not when new indexes are created.
When an index is added to an existing table, or when a column is added or dropped, index statistics are calculated and added to the innodb_index_stats table regardless of the value of innodb_stats_auto_recalc.
D is not about persistent indexed. E might be the answer but not sure
upvoted 2 times
...
This section is not available anymore. Please use the main Exam Page.1z0-908 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
abpg
5 months, 1 week ago7206e44
9 months, 1 week agojackymak
1 year, 2 months agoZehir
1 year, 5 months agoboyjhantan
1 year, 6 months agoavrely
2 months, 1 week agoboyjhantan
1 year, 6 months agonkanike1
1 year, 6 months agomarklv
1 year, 6 months ago