The ____ command analyzes the data in a table and creates statistics that the MySQL optimizer uses.
A)CHECK TABLE
B)ANALYZE TABLE
C)SHOW TABLE
D)FIND TABLE

Question

Quizplus · Accepted Answer

The ANALYZE TABLE command analyzes the data in a table and creates statistics that the MySQL optimizer uses for query optimization. CHECK TABLE is used to check for errors in the table and repair them, SHOW TABLE is used to display information about the table, and FIND TABLE is not a valid MySQL command.

The ____ Command Analyzes the Data in a Table and Creates