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 andits
contents have no problems. Which of
the following steps will you take to accomplish thetask? Each correct answer represents a part of thesolution.
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:
Answer A and CIn order to ensure that the contents in a table areaccessed 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 tablerepair is used for integrity checking and repairing
respectively. It ensures that the
table’s structure and contents have no problem.