Which of the following optimizations could be made based on data collected in the slow query log?

A. Tune server parameters.
B. Change the storage engines in use.
C. Make changes to the network infrastructure.
D. Rewrite queries to perform more efficiently.
E. Normalize data or add indexes to the tables that the queries use.

Answer: A,B,D,E

0 comments: