Use this command to recover the specified indexes.
To save time, indexes are not maintained when a backup is imported. These must be recovered explicitly. You recover damaged indexes or indexes that are no longer up to date.
The database software ignores damaged indexes. For this reason, they cannot cause errors, but do impair the performance of the database instance.
You have the DBM operator authorization AccessSQL.
You have opened an SQL session.
You have executed the command for restoring a database instance.
sql_recreateindex <scheme>.<table>.<index>
<scheme> |
Scheme |
<table> |
Table name |
<index> |
Index name or field name |
The system displays an OK message.
In the event of errors, see Reply Format.