You are a Database Administrator for MySQL database. Users are complaining of slow query
execution in a few tables. You need to ensure
that contents of those tables are accessed more efficiently. You are sure that the table structure and
its contents have no problems. Which of
the following steps will you take to accomplish the task?
Each correct answer represents a part of the solution. Choose two.

A.
Perform a table analysis operation.

B.
Perform a table repair operation.

C.
Perform a table optimization operation.

D.
Perform a table check operation.

Explanation:
In order to ensure that the contents in a table are accessed more efficiently, perform table analysis
and table optimization operations. A table
analysis updates statistics of distribution of index key values. It helps the optimizer to generate
better execution plans for queries on the
table. A table optimization reorganizes a table so that its contents are accessed more efficiently.
These operations can be performed for the
MyISAM and InnoDB tables.
Answer D and B are incorrect. Table check and table repair is used for integrity checking and
repairing respectively. It ensures that the
table’s structure and contents have no problem.