Oracle Indexes   «Prev  Next»

Storage Considerations for Indexes - Exercise

Adding indexes

Objective: Create additional indexes for the COIN database.

Exercise scoring

This exercise is worth a total of 10 points. Each of the indexes is worth 5 points.


You already created a script file with the SQL statements needed to create the tables in your COIN database and added constraints to the file. In this exercise, you will modify those scripts to include additional indexes.

Download files

You can download a correct version of the script for this exercise, indexes.sql, from the project download file found on the Resources page.


Add an index for the two foreign keys BIDDER_CLIENT_ID in the BID table and OWNER_CLIENT_ID in the COIN table.


You should not use either the UNIQUE or BITMAP keywords, because these indexes allow duplicate values.

Submitting your exercise

Submit your answer in the text box below.