Introduction
Single-column indexes
Multi-column indexes
Additional options when creating indexes
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.
