Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Understanding Indexes

Introduction
Single-column indexes
Multi-column indexes
Additional options when creating indexes
10. Deleting indexes
Summary

Instruction

Great job! We've created a multi-column index on the columns country and current_points. In the meantime, we realized that we no longer need this index:

CREATE INDEX points_index
ON player(current_points);

Removing an index is actually quite straightforward in SQL. Take a look:

DROP INDEX points_index;

The code above removes points_index from the database.

Exercise

In the first exercise, we created the following index for the column driver:

CREATE INDEX rides_index
ON driver(ride_count);

We no longer need it. Drop the index.