As you complete the tasks below, place your answers or comments on this document. After you complete all the tasks, write a summary of your answers and comments and post the summary to the discussion. Attach this document containing your answers and comments to your discussion posting.

Get familiar with Oracle indexes from an application developers perspective. Read Chapter 5, Using Indexes in Database Applications, from Database Advanced Application Developer's Guide. The guide is located at this URL: https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_indexes.htm#ADFNS005

Review the purpose of each index in the HR database identify system-defined indexes and user-defined indexes.

Create and populate the PROSPECT data files from the STUDENT table of the STUDENT database. You can use these commands:

Add primary key and foreign key constraints. Show the SQL to create the primary key and foreign key constraints in the space below.

Add indexes to the denormalized tables. Describe the purpose of the indexes. Show the SQL to create the indexes in the space below.

Application developers and database administrators are responsible for monitoring SQL execution by generating and interpreting SQL execution plans. Two resources on monitoring SQL execution for an Oracle database are Oracle Database Performance Tuning Guide, and Oracle Database SQL Tuning Guide.

Review the Oracles Database SQL Tuning Guide at http://docs.oracle.com/database/121/TGSQL/toc.htm and read about the new features of Oracle 12: The Adaptive SQL Plan Management (SPM), Adaptive query optimization, new types of histograms, Monitoring database operation, etc.

Review Oracles Database Performance Tuning Guide https://docs.oracle.com/database/121/TGDBA/toc.htm

Select at least two topics from guides to compare the performance of the two queries. Experiment with the indexes determine if they have an effect on the performance or execute of query 2.

List at least three resources in APA style that you used to complete the tasks.

List three things that you learned from this assignment.