RelationalDBDesign RelationalDBDesign 


Index Techniques   «Prev  Next»

Bitmapped Indexes - Exercise

Objective:Create a series of indexes.

Scoring

This exercise is worth a total of 10 points. Once you complete your answer, you will submit your answer.
You may not receive full credit for the answer if your syntax is only partially correct.

Background/overview

You have been asked to create a series of indexes on a CUSTOMER table. You have determined that the SQL queries would benefit from indexes on the following columns:
Customer_name
Region
State
Zip_code
Customer_business_type

You have also learned that there will be 50 distinct values for state, four distinct values for region, and 10 distinct values for customer_business_type.

Instructions

Create a set of index definitions for the customer table that allow the queries to use the index.

Submitting your exercise

Enter your answer into the text box below. Click the Submit button to submit the code.

Hints

Create bitmapped index xxxx
On
   Customer
(
    col
);