The ANALYZE TABLE command should be used...

The correct answer is B. To improve performance by updating index distribution statistics. C. After large amounts of table data have changed. The ANALYZE TABLE statement updates a table with information about the distribution of key values in the table. This information is used by the optimizer to make better choices about query execution plans. This statement works for MyISAM and InnoDB tables.

MySQL Database Maintenance

Question

Options

AWhen you need to find out why a query is taking a long time to execute.
BTo improve performance by updating index distribution statistics.
CAfter large amounts of table data have changed.
DTo check a tables structure to see if it may have been damaged and needs repair.

How the community answered

(32 responses)

A
16% (5)
B
75% (24)
D
9% (3)

Explanation

The ANALYZE TABLE statement updates a table with information about the distribution of key values in the table. This information is used by the optimizer to make better choices about query execution plans. This statement works for MyISAM and InnoDB tables.

Topics

#ANALYZE TABLE#index statistics#query optimization#table maintenance

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice