Oracle
1Z0-888 · Question #91
1Z0-888 Question #91: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-888 to reveal the answer and full explanation for question #91. The question stem and answer options stay visible for context.
Performance Tuning
Question
You have set innodb_stats_auto_recalc to OFF.
For tables using persistent statistics, what is the outcome of this change?
Options
- AInnoDB no longer automatically updates index statistics after a CREATE TABLE statement.
- BInnoDB no longer automatically updates index statistics after the table structure is altered.
- CInnoDB no longer automatically updates index statistics after 10% of the rows in a table change.
- DInnoDB no longer automatically updates index statistics after an ANALYZE TABLE statement.
Unlock 1Z0-888 to see the answer
You've previewed enough free 1Z0-888 questions. Unlock 1Z0-888 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#InnoDB Statistics#innodb_stats_auto_recalc#Automatic Recalculation#Query Optimization