37.6. Reindexing a Database #
The REINDEX SQL command is executed when reindexing.
To reindex a database:
In the navigation panel, go to Databases.
(Optional) To display system databases, turn on Show system databases.
Click
→ Reindex next to the database. Specify the reindexing parameters (parameters marked with an asterisk are required):
Set cron-string execution: Allows specifying the interval for reindexing in the crontab format.
If you turn on this toggle, in Execution, enter the string.
Execution: The type of the reindexing schedule.
Possible values:
Execute now: Reindexing will be performed immediately after you perform this instruction.
Once: Reindexing will be performed at the specified date and time.
On schedule: Reindexing will be performed at the specified interval.
For this value, specify the following parameters:
Interval: The unit of measurement of the interval.
Possible values:
Minutes
Hours
Days
Repeat every: The interval for reindexing by minutes or hours.
This parameter is available only if you select Minutes or Hours from Interval.
Execution days: The days when reindexing will be performed.
Cron total line: The string in the crontab format that specifies the interval for reindexing.
This parameter is available only if you turn off Set cron-string execution.
Name: The unique name of the reindexing task.
This parameter is available only if you turn on Set cron-string execution or select Once / Repeated from Execution.
Time: The date and/or time when reindexing will be performed.
This parameter is available only if you select Once from Execution or Days from Interval.
Start and Repeat untill: The start and end date and time for reindexing.
These parameters are available only if you turn on Set cron-string execution or select Repeated from Execution.
Confirm the operation.
Note
Depending on the number and size of indexes, this operation may require significant resources so it is recommended to track it.