Microsoft
98-364 · Question #61
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…
The correct answer is A. Perform a table analysis operation. C. Perform a table optimization operation. See the full explanation below for the reasoning.
Question
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.
Options
- APerform a table analysis operation.
- BPerform a table repair operation.
- CPerform a table optimization operation.
- DPerform a table check operation.
How the community answered
(30 responses)- A83% (25)
- B7% (2)
- D10% (3)
Community Discussion
No community discussion yet for this question.