Use this command to re-create bad indexes of the database system.
When you execute this command, only those indexes are re-created that are marked as bad. The command does not have any effect on good indexes.
You have the server permission AccessSQL.
You have opened a database session (see: db_connect).
sql_recreateindex [<index_specification>]
<index_specification> :: = <schema>.<table>.<index>
Option |
Description |
---|---|
<index_specification> |
Index specification <schema>: schema <table>: table name <index>: index name or field name If you do not specify that option, the system re-creates all indexes that are flagged as bad. |
OK
In the event of errors, see Reply Format.