IM300 Week 5 Learning Team Analyze the Execution Plan Letter
A member of your team questions the necessity of an execution plan for the new database system. You reply in a letter.
Resources: University of Phoenix Material: Execution Plan Instructions
Analyze the execution plan created by the database using the query and instructions found in the Execution Plan Instructions document.
Write a draft of your business letter to a database administrator including the following:
An explanation of why it is important for them to understand execution plans.
How execution plans can be used to improve the performance of the database.
Format your letter consistent with APA guidelines.
The execution plan is attached which I ran against the oracle DB HR and the attached pictures are the result.