Alter a secondary index (2i)

Secondary indexes (2i) cannot be altered. If you need to modify a 2i index, you will need to drop the current index, create a new index, and rebuild the cycling.

Prerequisites

Keyspace created
Table created

Secondary index (2i) created

Drop index
```
DROP INDEX IF EXISTS cycling.rank_idx;
```

Create new index

CREATE INDEX IF NOT EXISTS rank_idx 
  ON cycling.rank_by_year_and_name (rank);

Alter a secondary index (2i)

Prerequisites

Was this helpful?

Give Feedback