Modifying an Index

You modify an index using ALTER INDEX. The following example renames the i_old_index index to i_new_index:

ALTER INDEX i_old_index RENAME TO i_new_index;

1. Creating a B-tree Index
2. Composite Index
3. Retrieving Information on Indexes
4. Modifying an Index
5. Dropping an Index
6. Creating a Bitmap Index