40.3. Reindexing an Index #
The REINDEX SQL command is executed when reindexing.
To reindex an index:
In the navigation panel, go to Databases.
(Optional) To display system databases, turn on Show system databases.
Click the name of the database.
Click the name of the schema.
Click the name of the table.
Select Indexes.
Click Reindex next to the index.
Specify the reindexing parameters (parameters marked with an asterisk are required):
Concurrently: Specifies whether the operation will be performed in the non-locking mode. This is the safest mode that allows avoiding locking other sessions by slowing down the process of reindexing.
Possible values:
On
Off
Tablespace: The tablespace where the index will be reindexed.
Click Execute.
The reindexing task will start.
Note
Depending on the number and size of indexes, this operation may require significant resources so it is recommended to track it.