RelationalDBDesign RelationalDBDesign


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.

Background/overview

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.

Instructions

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

Hints

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.