Reindex()

Reindexes the database.

Note:

You must have Administrative permissions to reindex.

Parameters

Type

SQL_VARCHAR(1024)

The type of reindex. The default is BACKGROUND_PREFERRED.

Index_Comments

SQL_BIT

1 if comments should also be reindexed, 0 otherwise. The default is 0. Not relevant for foreground index.

Index_Change_History

SQL_BIT

1 if change history should also be reindexed, 0 otherwise. The default is 0. Not relevant for foreground index.

Index_Worklogs

SQL_BIT

1 if worklogs should also be reindexed, 0 otherwise. The default is 0. Not relevant for foreground index.

Returns

If the procedure fails, it throws an exception.

Otherwise, the procedure returns a table with rows representing the progress of the reindex operation.