Assignment: Database Optimization and Performance Tuning Paper
In a 500 to 750 words document, address the following:
I. Explain the phases and function of the query optimizer.
II. Identify the tools to edit query optimizer strategies.
III. Explain how performance of a database system is measured.
IV. Differentiate between response time and throughput.
V. Explain how the physical design of a database influences performance tuning.
VI. Explain three ways queries can be altered to increase database performance.
VII. Present specific examples to illustrate how implementing each query alteration could optimize the database.
Format your assignment according to the give formatting requirements:
1. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the course title, the student's name, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.