Entering content frame

Procedure documentation Recreating a Damaged Index Locate the document in its SAP Library structure

Use

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.

Note

The database software ignores damaged indexes. For this reason, they cannot cause errors, but do impair the performance of the database instance.

Prerequisites

You have the DBM operator authorization AccessSQL.

You have opened an SQL session.

You have executed the command for restoring a database instance.

Syntax

sql_recreateindex <scheme>.<table>.<index>

<scheme>

Scheme

<table>

Table name

<index>

Index name or field name

Reply

The system displays an OK message.

In the event of errors, see Reply Format.

 

Leaving content frame