RelationalDBDesign
SiteMap
Database Creation
Database Admin
Managing Connectivity
Managing DB Objects
Oracle Indexes
«Prev
Next»
Managing Objects
Space Management
Coalesce Tablespace
Storage Management Concepts
Setting Extent Size
Table Space Fragmentation
Correct Table Space
Data System Blocks
Managing Tables
Schema Manager Table
Creating Table Syntax
Managing Constraints
Four Basic Constraints
Primary Key Constraints
Data Dictionary Constraints
Oracle Indexes
Oracle Database Index
Drop Index Oracle
Managing Privileges
Listing Privileges Columns
Revoking Object Privileges
Database Security Roles
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.
Submit