Validating an index

You can validate an index to ensure that every row referenced in the index actually exists in the table. For foreign key indexes, a validation check also ensures that the corresponding row exists in the primary table.

Prérequis

You must be the owner of the index, or have the VALIDATE ANY OBJECT system privilege.

Perform validation only when no connections are making changes to the database.

Task

In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, double-click Indexes.
Right-click an index and click Validate.
Click OK.

Résultat

A check is done to ensure that every row referenced in the index actually exists in the table. For foreign key indexes, the check ensures that the corresponding row exists in the primary table.

Validating an index

Task

See also