The purpose of this assignment is to determine if the database performance can be improved by monitoring response times for frequently used queries and determining if the queries were written correctly and produced the expected results.
- Explain three ways queries can be altered to increase database performance.
- Include specific examples to illustrate how implementing each query alteration could optimize the database.