ALTER INDEX

Description

Use the ALTER INDEX statement to rebuild an index. (That is, drop and rebuild an index.) There are the following two ways to specify an index to be rebuilt:

Syntax

ALTER [ REVERSE ] [ UNIQUE ] INDEX index_name
[ON { ONLY } table_name ( column_name [ {, column_name } ...) ] REBUILD [ ; ]

ALTER [ REVERSE ] [ UNIQUE ] INDEX
ON { ONLY } table_name ( column_name [ {, column_name } ...) REBUILD [ ; ]

Example

The following are examples of many ways of re-creating indexes:

ALTER INDEX i_game medal ON game(medal) REBUILD;

ALTER INDEX game_date_idx REBUILD;