The companys IT department has decided to migrate the system to MySQL as a step towards migrating the entire system to a web-based platform and to use its existing hardware. As part of the process, they have looked at the activity of the current Oracle based system to identify the frequency and types of queries that are being ran and how they may mitigate against how the system may be scaled up.

Explain the three types of optimisation techniques that they need to consider with respect to a MySQL deployment.